使用Excel在Excel中绘制图形 [英] Draw graph in Excel using

问题描述

我在java中有一个Windows应用程序。在这个应用程序中，我必须在MsExcel中绘制一个grap。当我单击绘制图形按钮时，将打开该文件，并且应该在此MsExcel中绘制grap。输入是从一个txt文件给出的。





谢谢，

Velkumar

Hi,

I have a windows application in java. In this applicaation i have to draw a grap in MsExcel. When I click a button "Draw Graph" the file will be opened and the grap should be drawn in this MsExcel. The input is given from a txt file.


Thanks,
Velkumar

推荐答案

Apache POI [ ^ ]是你需要做的。



Apache POI-HSSF和POI-XSSF [ ^ ]。

请查看该网页左侧的菜单以获取更多信息（文档） ，教程/示例等。）

Apache POI[^] is what you will need to do this.

Apache POI-HSSF and POI-XSSF[^] are needed to work with Excel data.
PLease check the menu on the left side of that webpage for more info (documentation, tutorial/examples etc.)

1000000000 -1.683207439

1050000000 -1.742464967

1100000000 -1.812607964

1150000000 -1.897426337

1200000000 -2.065119286

1250000000 -2.366731619

1300000000 -2.813920841

1350000000 -3.40740475

1400000000 -4.1831137 2

1450000000 -5.266893333

1500000000 -6.68381373

1550000000 -8.526856752

1600000000 -10.50933575

1650000000 -11.73003765

1700000000 -11.44336963

1750000000 -10.63392383

1800000000 -9.903194938

1850000000 -9.256626832

1900000000 -8.678433548

1950000000 -8.418471688

2000000000 -8.300173327

2050000000 -8.386203119

2100000000 -8.333950572

2150000000 -8.362249692

2200000000 -8.499994408

2250000000 -8.532926844

2300000000 -8.522096575

2350000000 -8.021276323

2400000000 -7.515507964

2450000000 -6.887695336

2500000000 -6.329310836

2550000000 -5.874571389

2600000000 -5.555926863

2650000000 -5.298367311

2700000000 -5.193726638

2750000000 -5.196841596

2800000000 -5.301897235

28500000 00 -5.427520353

2900000000 -5.582116629

2950000000 -5.734772958

3000000000 -5.93863163

3050000000 -6.054756863

3100000000 -6.440020468

3150000000 -6.773278151

3200000000 -7.255819385

3250000000 -7.785571994

3300000000 -8.325670454

3350000000 -9.169296633

3400000000 -9.926328879

3450000000 -10.67698812

3500000000 -11.3936649

3550000000 -12.48241308

3600000000 -13.94039307

3650000000 -15.79033886

3700000000 -18.10548025

3750000000 - 20.8765071

3800000000 -23.94360655

3850000000 -25.28450213

3900000000 -25.13988541

3950000000 -23.96690538

4000000000 -22.38870147

4050000000 -21.2427774

4100000000 -19.64864582

4150000000 -18.45827153

4200000000 -17.46735757

4250000000 -16.87701003

4300000000 -16.06999842

4350000000 -15.25208733

4400000000 -14.52169131

4450000000 -13.98857659

4500000000 -13.65227168

4550000000 -13.59763551

4600000000 -13.67608908

4650000000 -13.94873942

4700000000 -14.10832295

4750000000 -14.42936641

4800000000 -15.14696235

4850000000 -15.65110165

4900000000 -16.67065557

4950000000 -17.57033187

5000000000 -18.72875994

5050000000 -19.42888778

5100000000 -19.50988212

5150000000 -19.6334493

5200000000 -19.61097247

5250000000 -19.28472681

5300000000 -18.7483294

5350000000 -17.87153668

5400000000 -17.28345104

5450000000 -15.98504552

5500000000 -15.02276466

5550000000 -14.13629347

5600000000 -13.33242397

5650000000 -12.7914041

5700000000 -12.39247 404

5750000000 -12.21671289

5800000000 -12.16052646

5850000000 -12.21521891

5900000000 -12.15659696

5950000000 -12.19976302

6000000000 -12.14397143

6050000000 -12.23592744

6100000000 -12.45275707

6150000000 -12.82848165

6200000000 -13.26158557

6250000000 -13.86806182

6300000000 -14.58700005

6350000000 -15.41900236

6400000000 -16.33559266

6450000000 -17.26128438

6500000000 -18.22659119

6550000000 -19.27000925

6600000000 -20.53419977

6650000000 -21.946344

6700000000 -24.07317769

6750000000 -25.81470257

6800000000 -26.98238034

6850000000 -27.22663423

6900000000 -24.28940613

6950000000 -22.63500855

7000000000 -21.53888667

7050000000 -20.45716146

7100000000 -19.9166011

71500000 00 -19.04518852

7200000000 -18.46171055

7250000000 -17.56721989

7300000000 -16.78774223

7350000000 -16.13382473

7400000000 -16.13209812

7450000000 -15.22814972

7500000000 -15.00238306

7550000000 -14.94973484

7600000000 -15.02592938

7650000000 -15.11153876

7700000000 -15.34359573

7750000000 -15.52598795

7800000000 -15.86301011

7850000000 -16.23859203

7900000000 -16.45054189

7950000000 -17.29555822

8000000000 -17.88533258

8050000000 - 18.75041252

8100000000 -20.13012935

8150000000 -21.51981019

8200000000 -23.449726

8250000000 -25.71848402

8300000000 -29.60976448

8350000000 -34.88186366

8400000000 -36.68479175

8450000000 -30.08164749

8500000000 -25.15014474

8550000000 -21.94641594

8600000000 -19.69473295

8650000000 -17.71935562

8700000000 -16.40544364

8750000000 -15.33792434

8800000000 - 14.34348021

8850000000 -13.47020459

8900000000 -12.60221033

8950000000 -11.87230036

9000000000 -11.17298522

9050000000 -10.51270492

9100000000 -9.977194591

9150000000 -9.551198982

9200000000 -9.332232755

9250000000 -9.086107769

9300000000 -8.926146762

9350000000 -8.85705511

9400000000 -8.71304063

9450000000 -8.509408405

9500000000 -8.255872143

9550000000 -8.010005526

9600000000 -7.750784673

9650000000 -7.482098509

9700000000 -7.417427405

9750000000 -7.369808585

9800000000 -7.349623269

9850000000 -7.35427564

9900000000 -7.36361167

9950000000 -7.289649785

10000000000 -7.1666 05915

10050000000 -7.036764654

10100000000 -6.863746306

10150000000 -6.61176431

10200000000 -6.56381116

10250000000 -6.483926684

10300000000 -6.483077394

10350000000 -6.532080961

10400000000 -6.478203879

10450000000 -6.380175141

10500000000 -6.192119015

10550000000 -5.944851185

10600000000 -5.656550695

10650000000 -5.304418211

10700000000 -5.132588116

10750000000 -4.941635522

10800000000 -4.839276547

10850000000 -4.786010949

10900000000 -4.742133238

10950000000 -4.647455869

11000000000 -4.548030958

1000000000 -1.683207439
1050000000 -1.742464967
1100000000 -1.812607964
1150000000 -1.897426337
1200000000 -2.065119286
1250000000 -2.366731619
1300000000 -2.813920841
1350000000 -3.40740475
1400000000 -4.18311372
1450000000 -5.266893333
1500000000 -6.68381373
1550000000 -8.526856752
1600000000 -10.50933575
1650000000 -11.73003765
1700000000 -11.44336963
1750000000 -10.63392383
1800000000 -9.903194938
1850000000 -9.256626832
1900000000 -8.678433548
1950000000 -8.418471688
2000000000 -8.300173327
2050000000 -8.386203119
2100000000 -8.333950572
2150000000 -8.362249692
2200000000 -8.499994408
2250000000 -8.532926844
2300000000 -8.522096575
2350000000 -8.021276323
2400000000 -7.515507964
2450000000 -6.887695336
2500000000 -6.329310836
2550000000 -5.874571389
2600000000 -5.555926863
2650000000 -5.298367311
2700000000 -5.193726638
2750000000 -5.196841596
2800000000 -5.301897235
2850000000 -5.427520353
2900000000 -5.582116629
2950000000 -5.734772958
3000000000 -5.93863163
3050000000 -6.054756863
3100000000 -6.440020468
3150000000 -6.773278151
3200000000 -7.255819385
3250000000 -7.785571994
3300000000 -8.325670454
3350000000 -9.169296633
3400000000 -9.926328879
3450000000 -10.67698812
3500000000 -11.3936649
3550000000 -12.48241308
3600000000 -13.94039307
3650000000 -15.79033886
3700000000 -18.10548025
3750000000 -20.8765071
3800000000 -23.94360655
3850000000 -25.28450213
3900000000 -25.13988541
3950000000 -23.96690538
4000000000 -22.38870147
4050000000 -21.2427774
4100000000 -19.64864582
4150000000 -18.45827153
4200000000 -17.46735757
4250000000 -16.87701003
4300000000 -16.06999842
4350000000 -15.25208733
4400000000 -14.52169131
4450000000 -13.98857659
4500000000 -13.65227168
4550000000 -13.59763551
4600000000 -13.67608908
4650000000 -13.94873942
4700000000 -14.10832295
4750000000 -14.42936641
4800000000 -15.14696235
4850000000 -15.65110165
4900000000 -16.67065557
4950000000 -17.57033187
5000000000 -18.72875994
5050000000 -19.42888778
5100000000 -19.50988212
5150000000 -19.6334493
5200000000 -19.61097247
5250000000 -19.28472681
5300000000 -18.7483294
5350000000 -17.87153668
5400000000 -17.28345104
5450000000 -15.98504552
5500000000 -15.02276466
5550000000 -14.13629347
5600000000 -13.33242397
5650000000 -12.7914041
5700000000 -12.39247404
5750000000 -12.21671289
5800000000 -12.16052646
5850000000 -12.21521891
5900000000 -12.15659696
5950000000 -12.19976302
6000000000 -12.14397143
6050000000 -12.23592744
6100000000 -12.45275707
6150000000 -12.82848165
6200000000 -13.26158557
6250000000 -13.86806182
6300000000 -14.58700005
6350000000 -15.41900236
6400000000 -16.33559266
6450000000 -17.26128438
6500000000 -18.22659119
6550000000 -19.27000925
6600000000 -20.53419977
6650000000 -21.946344
6700000000 -24.07317769
6750000000 -25.81470257
6800000000 -26.98238034
6850000000 -27.22663423
6900000000 -24.28940613
6950000000 -22.63500855
7000000000 -21.53888667
7050000000 -20.45716146
7100000000 -19.9166011
7150000000 -19.04518852
7200000000 -18.46171055
7250000000 -17.56721989
7300000000 -16.78774223
7350000000 -16.13382473
7400000000 -16.13209812
7450000000 -15.22814972
7500000000 -15.00238306
7550000000 -14.94973484
7600000000 -15.02592938
7650000000 -15.11153876
7700000000 -15.34359573
7750000000 -15.52598795
7800000000 -15.86301011
7850000000 -16.23859203
7900000000 -16.45054189
7950000000 -17.29555822
8000000000 -17.88533258
8050000000 -18.75041252
8100000000 -20.13012935
8150000000 -21.51981019
8200000000 -23.449726
8250000000 -25.71848402
8300000000 -29.60976448
8350000000 -34.88186366
8400000000 -36.68479175
8450000000 -30.08164749
8500000000 -25.15014474
8550000000 -21.94641594
8600000000 -19.69473295
8650000000 -17.71935562
8700000000 -16.40544364
8750000000 -15.33792434
8800000000 -14.34348021
8850000000 -13.47020459
8900000000 -12.60221033
8950000000 -11.87230036
9000000000 -11.17298522
9050000000 -10.51270492
9100000000 -9.977194591
9150000000 -9.551198982
9200000000 -9.332232755
9250000000 -9.086107769
9300000000 -8.926146762
9350000000 -8.85705511
9400000000 -8.71304063
9450000000 -8.509408405
9500000000 -8.255872143
9550000000 -8.010005526
9600000000 -7.750784673
9650000000 -7.482098509
9700000000 -7.417427405
9750000000 -7.369808585
9800000000 -7.349623269
9850000000 -7.35427564
9900000000 -7.36361167
9950000000 -7.289649785
10000000000 -7.166605915
10050000000 -7.036764654
10100000000 -6.863746306
10150000000 -6.61176431
10200000000 -6.56381116
10250000000 -6.483926684
10300000000 -6.483077394
10350000000 -6.532080961
10400000000 -6.478203879
10450000000 -6.380175141
10500000000 -6.192119015
10550000000 -5.944851185
10600000000 -5.656550695
10650000000 -5.304418211
10700000000 -5.132588116
10750000000 -4.941635522
10800000000 -4.839276547
10850000000 -4.786010949
10900000000 -4.742133238
10950000000 -4.647455869
11000000000 -4.548030958

这篇关于使用Excel在Excel中绘制图形的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！