java workbook 保存_利用java程序将表格保存成excel格式的文件全代码

Java代码

1.import org.apache.poi.hssf.usermodel.*;

2.import org.apache.poi.hssf.util.HSSFColor;

3.

4.import java.awt.*;

5.

6.import java.io.FileOutputStream;

7.import java.io.IOException;

8.

9.import javax.swing.*;

10.import javax.swing.table.*;

11.

12./**

13. *

Title: com.gwtt.tools.export.ExportXlsUtil

14. *

Description: ??JTable????????excel????С?

15. *

Copyright: Copyright (c) 2004

16. *

Company: GWTT

17. * @author Laura

18. * @version 1.0

19. */

20.public class ExportXlsUtil {

21.  private HSSFWorkbook workbook = null;

22.  private HSSFSheet sheet = null;

23.

24.  public ExportXlsUtil () {

25.    workbook = new HSSFWorkbook();

26.    sheet = workbook.createSheet(“sheet1”);

27.

28.  }

29.

30.  /**

31.   * ??table?????????????excel???

32.   * @param data??JTable?е????

33.

34.   * @param columnNames??JTable????

35.   * @param filename??excel??????·????

36.   */

37.  public void exportTableToXls (Object [][] data,

38.                                Object [] columnNames,

39.                                String filename)

40.                         throws IOException {

41.    JTable table = new JTable(data, columnNames);

42.    exportTableToSheet(table, sheet);

43.    FileOutputStream fout = new FileOutputStream(filename);

44.    workbook.write(fout);

45.    fout.close() ;

46.  }

47.

48.  /**

49.   * ??JTable????????HSSFSheet??

50.   * @param table ????????JTable??

51.   * @param sheet ?????HSSFSheet

52.   */

53.  private void exportTableToSheet (JTable table,

54.                                   HSSFSheet sheet) {

55.    int rowCount = table.getRowCount();

56.    int colCount = table.getColumnCount();

57.    //填充了表头到excel中???????

58.    createAndFormatHeader(table, sheet);

59.    int currentSheetRow = 1;

60.    //填充了表的内容到excel中?????????

61.    for (int tableRowIndex = 0; tableRowIndex < rowCount; tableRowIndex++) {

62.      for (int tableColIndex = 0; tableColIndex < colCount; tableColIndex++) {

63.        // create and format the cell in the spreadsheet

64.        createAndFormatCell(table, tableRowIndex, tableColIndex, sheet,

65.                            currentSheetRow);

66.      }

67.      currentSheetRow++;  //换行

68.    }

69.  }

70.

71.  /**

72.   * ???????????Excel??????

73.   */

74.  private void createAndFormatCell (JTable table,

75.                                    int tableRowIndex,

76.                                    int tableColIndex,

77.                                    HSSFSheet sheet,

78.                                    int currentSheetRow) {

79.    // get the cell value from the table

80.    Object cellValue = table.getValueAt(tableRowIndex, tableColIndex);

81.

82.    // create the cell

83.    HSSFCell cell = createHSSFCell(sheet, cellValue, currentSheetRow,

84.                                   tableColIndex);

85.

86.    // get the renderer component that renders the cell

87.    TableCellRenderer renderer = table.getCellRenderer(tableRowIndex,

88.                                                       tableColIndex);

89.    Component rendererComponent = renderer.getTableCellRendererComponent(table,

90.                                                                         cellValue,

91.                                                                         false,

92.                                                                         false,

93.                                                                         tableRowIndex,

94.                                                                         tableColIndex);

95.

96.    if (rendererComponent instanceof JLabel) {

97.      // if it is a JLabel, get the label text which is the actual formatted displayed text

98.      // and not the raw cell value

99.      JLabel label = (JLabel)rendererComponent;

100.      cellValue = label.getText();

101.

102.

103.    }

104.

105.    formatCell(cell, rendererComponent);

106.  }

107.

108.  /**

109.   * ??????????????

110.   */

111.  private void createAndFormatHeader (JTable table,

112.                                      HSSFSheet sheet) {

113.    for (int colIndex = 0; colIndex < table.getColumnCount(); colIndex++) {

114.      // get the cell value from the table

115.      Object cellValue = table.getColumnName(colIndex); //得到表的列名

116.

117.      // create the cell

118.      HSSFCell cell = createHSSFCell(sheet, cellValue, 0, colIndex);

119.

120.      // get the renderer component that renders the cell

121.      TableCellRenderer renderer = table.getDefaultRenderer(table

122.                                                            .getColumnClass(colIndex));

123.      Component rendererComponent = renderer.getTableCellRendererComponent(table,

124.                                                                           cellValue,

125.                                                                           false,

126.                                                                           false,

127.                                                                           0,

128.                                                                           colIndex);

129.

130.      if (rendererComponent instanceof JLabel) {

131.        // if it is a JLabel, get the label text which is the actual formatted displayed text

132.        // and not the raw cell value

133.        JLabel label = (JLabel)rendererComponent;

134.        cellValue = label.getText();

135.      }

136.

137.      formatCell(cell, rendererComponent);

138.

139.    }

140.  }

141.

142.  //设置一个单元格的值

143.  private HSSFCell createHSSFCell (HSSFSheet sheet,

144.                                   Object value,

145.                                   int row,

146.                                   int col) {

147.    // create row if not yet created

148.    HSSFRow hssfRow = sheet.getRow(row);           //一行

149.    hssfRow = (hssfRow == null)

150.              ? sheet.createRow(row)

151.              : hssfRow;

152.

153.    // create cell if not yet created

154.    HSSFCell cell = hssfRow.getCell((short)col);   //一个单元格

155.    cell = (cell == null)

156.           ? hssfRow.createCell((short)col)

157.           : cell;

158.

159.    // set the cell value

160.    String cellValue = (value == null)

161.                       ? “”

162.                       : value.toString();

163.

164.    cell.setEncoding(HSSFCell.ENCODING_UTF_16 );

165.    cell.setCellValue(cellValue);

166.

167.    return cell;

168.  }

169.

170.  private void formatCell (HSSFCell cell,

171.                           Component rendererComponent) {

172.

173.      /*

174.      // create a style

175.    HSSFCellStyle cellStyle = workbook.createCellStyle();

176.

177.    // set the cell color

178.    cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

179.

180.    Color color = rendererComponent.getBackground();

181.

182.    //HSSFPalette palette = workbook.getCustomPalette();

183.    // maintain(increment after each use) unused color index as an instance variable

184.    short someUnusedColorIndex = 10;

185.

186.    // palette.setColorAtIndex(someUnusedColorIndex, (byte)color.getRed(),

187.    //                       (byte)color.getGreen(), (byte)color.getBlue());

188.    //cellStyle.setFillForegroundColor(someUnusedColorIndex);

189.    cellStyle.setFillForegroundColor(HSSFColor.WHITE.index);  //.setFillForegroundColor(someUnusedColorIndex);

190.

191.    // set the font

192.    Font font = rendererComponent.getFont();

193.

194.

195.    HSSFFont hssfFont = createHSSFFont(font);

196.    System.err.println(“xxxxxxxx  ” + font.toString()) ;

197.    System.err.println(hssfFont.FONT_ARIAL  ) ;

198.   // cellStyle.setFont(hssfFont);

199.

200.    // set the border

201.    cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);

202.    cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);

203.    cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);

204.    cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);

205.

206.

207.    // don't forget to set the cell style!

208.    cell.setCellStyle(cellStyle);

209.    */

210.    cell.setEncoding(HSSFCell.ENCODING_UTF_16) ;

211.  }

212.

213.  private HSSFFont createHSSFFont (Font font) {

214.    HSSFFont hssfFont = workbook.createFont();

215.    hssfFont.setFontName(font.getName());

216.    hssfFont.setItalic(font.isItalic());

217.    hssfFont.setBoldweight(font.isBold()

218.                           ? HSSFFont.BOLDWEIGHT_BOLD

219.                           : HSSFFont.BOLDWEIGHT_NORMAL);

220.    hssfFont.setFontHeightInPoints((short)font.getSize());

221.    hssfFont.setUnderline(HSSFFont.U_NONE);

222.

223.    return hssfFont;

224.  }

225.

226.  public static void main (String [] args) {

227.    Object [][] data = new Object[120][5];

228.    data[0] = new Object [] { “??δ?”, “Red”, “A”, new Integer(1), new Double(1.1) };

229.    data[1] = new Object [] { “Two”, “Red”, “A”, new Integer(2), new Double(2.2) };

230.    data[2] = new Object [] { “Three”, “Red”, “A”, new Integer(3), new Double(3.3) };

231.    data[3] = new Object [] {

232.                “Four”, “Green”, “A”, new Integer(4), new Double(4.4)

233.              };

234.    data[4] = new Object [] {

235.                “Five”, “Green”, “A”, new Integer(5), new Double(5.5)

236.              };

237.    data[5] = new Object [] { “Six”, “Green”, “A”, new Integer(6), new Double(6.6) };

238.    data[6] = new Object [] {

239.                “Seven”, “Green”, “A”, new Integer(7), new Double(7.7)

240.              };

241.    data[7] = new Object [] {

242.                “Eight”, “Green”, “A”, new Integer(8), new Double(8.8)

243.              };

244.    data[8] = new Object [] { “Nine”, “Blue”, “A”, new Integer(9), new Double(9.9) };

245.    data[9] = new Object [] {

246.                “Ten”, “Blue”, “A”, new Integer(10), new Double(10.10)

247.              };

248.    data[10] = new Object [] {

249.                 “Eleven”, “Blue”, “A”, new Integer(11), new Double(11.11)

250.               };

251.    data[11] = new Object [] {

252.                 “Twelve”, “Blue”, “A”, new Integer(12), new Double(12.12)

253.               };

254.    data[12] = new Object [] {

255.                 “Thirteen”, “Blue”, “A”, new Integer(13), new Double(13.13)

256.               };

257.    data[13] = new Object [] {

258.                 “Fourteen”, “Blue”, “A”, new Integer(14), new Double(14.14)

259.               };

260.    data[14] = new Object [] {

261.                 “Fifteen”, “Blue”, “A”, new Integer(15), new Double(15.15)

262.               };

263.    data[15] = new Object [] {

264.                 “Sixteen”, “Blue”, “A”, new Integer(16), new Double(16.16)

265.               };

266.    data[16] = new Object [] {

267.                 “Seventeen”, “Blue”, “A”, new Integer(17), new Double(17.17)

268.               };

269.    data[17] = new Object [] {

270.                 “Eighteen”, “Blue”, “A”, new Integer(18), new Double(18.18)

271.               };

272.    data[18] = new Object [] {

273.                 “Nineteen”, “Green”, “B”, new Integer(19), new Double(19.19)

274.               };

275.    data[19] = new Object [] {

276.                 “Twenty”, “Green”, “B”, new Integer(20), new Double(20.20)

277.               };

278.    data[20] = new Object [] {

279.                 “Twenty One”, “Green”, “B”, new Integer(21), new Double(21.21)

280.               };

281.    data[21] = new Object [] {

282.                 “Twenty Two”, “Green”, “B”, new Integer(22), new Double(22.22)

283.               };

284.    data[22] = new Object [] {

285.                 “Twenty Three”, “Green”, “B”, new Integer(23),

286.                 new Double(23.23)

287.               };

288.    data[23] = new Object [] {

289.                 “Twenty Four”, “Green”, “B”, new Integer(24), new Double(24.24)

290.               };

291.    data[24] = new Object [] {

292.                 “Twenty Five”, “Green”, “B”, new Integer(25), new Double(25.25)

293.               };

294.    data[25] = new Object [] {

295.                 “Twenty Six”, “Green”, “B”, new Integer(26), new Double(26.26)

296.               };

297.    data[26] = new Object [] {

298.                 “Twenty Seven”, “Green”, “B”, new Integer(27),

299.                 new Double(27.27)

300.               };

301.    data[27] = new Object [] {

302.                 “Twenty Eight”, “Green”, “B”, new Integer(28),

303.                 new Double(28.28)

304.               };

305.    data[28] = new Object [] {

306.                 “Twenty Nine”, “Red”, “C”, new Integer(29), new Double(29.29)

307.               };

308.    data[29] = new Object [] {

309.                 “Thirty”, “Red”, “C”, new Integer(30), new Double(30.30)

310.               };

311.    data[30] = new Object [] {

312.                 “Thirty One”, “Red”, “C”, new Integer(31), new Double(31.31)

313.               };

314.    data[31] = new Object [] {

315.                 “Thirty Two”, “Red”, “C”, new Integer(32), new Double(32.32)

316.               };

317.    data[32] = new Object [] {

318.                 “Thirty Three”, “Red”, “C”, new Integer(33), new Double(33.33)

319.               };

320.    data[33] = new Object [] {

321.                 “Thirty Four”, “Red”, “C”, new Integer(34), new Double(34.34)

322.               };

323.    data[34] = new Object [] {

324.                 “Thirty Five”, “Red”, “C”, new Integer(35), new Double(35.35)

325.               };

326.    data[35] = new Object [] {

327.                 “Thirty Six”, “Red”, “C”, new Integer(36), new Double(36.36)

328.               };

329.    data[36] = new Object [] {

330.                 “Thirty Seven”, “Blue”, “C”, new Integer(37), new Double(37.37)

331.               };

332.    data[37] = new Object [] {

333.                 “Thirty Eight”, “Blue”, “C”, new Integer(38), new Double(38.38)

334.               };

335.    data[38] = new Object [] {

336.                 “Thirty Nine”, “Blue”, “C”, new Integer(39), new Double(39.39)

337.               };

338.    data[39] = new Object [] {

339.                 “Forty”, “Blue”, “C”, new Integer(40), new Double(40.40)

340.               };

341.    data[40] = new Object [] {

342.                 “Forty One”, “Blue”, “C”, new Integer(41), new Double(41.41)

343.               };

344.    data[41] = new Object [] {

345.                 “Forty Two”, “Blue”, “C”, new Integer(42), new Double(42.42)

346.               };

347.    data[42] = new Object [] {

348.                 “Forty Three”, “Blue”, “D”, new Integer(43), new Double(43.43)

349.               };

350.    data[43] = new Object [] {

351.                 “Forty Four”, “Blue”, “D”, new Integer(44), new Double(44.44)

352.               };

353.    data[44] = new Object [] {

354.                 “Forty Five”, “Blue”, “D”, new Integer(45), new Double(45.45)

355.               };

356.    data[45] = new Object [] {

357.                 “Forty Six”, “Blue”, “D”, new Integer(46), new Double(46.46)

358.               };

359.    data[46] = new Object [] {

360.                 “Forty Seven”, “Blue”, “D”, new Integer(47), new Double(47.47)

361.               };

362.    data[47] = new Object [] {

363.                 “Forty Eight”, “Blue”, “D”, new Integer(48), new Double(48.48)

364.               };

365.    data[48] = new Object [] {

366.                 “Forty Nine”, “Blue”, “D”, new Integer(49), new Double(49.49)

367.               };

368.    data[49] = new Object [] {

369.                 “Fifty”, “Blue”, “D”, new Integer(50), new Double(50.50)

370.               };

371.    data[50] = new Object [] {

372.                 “Fifty One”, “Blue”, “D”, new Integer(51), new Double(51.51)

373.               };

374.    data[51] = new Object [] {

375.                 “Fifty Two”, “Blue”, “D”, new Integer(52), new Double(52.52)

376.               };

377.    data[52] = new Object [] {

378.                 “Fifty Three”, “Blue”, “D”, new Integer(53), new Double(53.53)

379.               };

380.    data[53] = new Object [] {

381.                 “Fifty Four”, “Blue”, “D”, new Integer(54), new Double(54.54)

382.               };

383.    data[54] = new Object [] {

384.                 “Fifty Five”, “Blue”, “D”, new Integer(55), new Double(55.55)

385.               };

386.    data[55] = new Object [] {

387.                 “Fifty Six”, “Blue”, “D”, new Integer(56), new Double(56.56)

388.               };

389.    data[56] = new Object [] {

390.                 “Fifty Seven”, “Blue”, “D”, new Integer(57), new Double(57.57)

391.               };

392.    data[57] = new Object [] {

393.                 “Fifty Eight”, “Blue”, “D”, new Integer(58), new Double(58.58)

394.               };

395.    data[58] = new Object [] {

396.                 “Fifty Nine”, “Blue”, “D”, new Integer(59), new Double(59.59)

397.               };

398.    data[59] = new Object [] {

399.                 “Sixty”, “Blue”, “D”, new Integer(60), new Double(60.60)

400.               };

401.    data[60] = new Object [] {

402.                 “Sixty One”, “Blue”, “D”, new Integer(61), new Double(61.60)

403.               };

404.    data[61] = new Object [] {

405.                 “Sixty Two”, “Blue”, “D”, new Integer(62), new Double(62.60)

406.               };

407.    data[62] = new Object [] {

408.                 “Sixty Three”, “Blue”, “D”, new Integer(63), new Double(63.60)

409.               };

410.    data[63] = new Object [] {

411.                 “Sixty Four”, “Blue”, “D”, new Integer(64), new Double(64.60)

412.               };

413.    data[64] = new Object [] {

414.                 “Sixty Five”, “Blue”, “D”, new Integer(65), new Double(65.60)

415.               };

416.    data[65] = new Object [] {

417.                 “Sixty Six”, “Blue”, “D”, new Integer(66), new Double(66.60)

418.               };

419.    data[66] = new Object [] {

420.                 “Sixty Seven”, “Blue”, “D”, new Integer(67), new Double(67.60)

421.               };

422.    data[67] = new Object [] {

423.                 “Sixty Eight”, “Blue”, “D”, new Integer(68), new Double(68.60)

424.               };

425.    data[68] = new Object [] {

426.                 “Sixty Nine”, “Blue”, “D”, new Integer(69), new Double(69.60)

427.               };

428.    data[69] = new Object [] {

429.                 “Seventy”, “Blue”, “D”, new Integer(70), new Double(70.60)

430.               };

431.    data[70] = new Object [] {

432.                 “Seventy One”, “Blue”, “D”, new Integer(71), new Double(71.60)

433.               };

434.    data[71] = new Object [] {

435.                 “Seventy Two”, “Blue”, “D”, new Integer(72), new Double(72.60)

436.               };

437.    data[72] = new Object [] {

438.                 “Seventy Three”, “Blue”, “D”, new Integer(73),

439.                 new Double(73.60)

440.               };

441.    data[73] = new Object [] {

442.                 “Seventy Four”, “Blue”, “D”, new Integer(74), new Double(74.60)

443.               };

444.    data[74] = new Object [] {

445.                 “Seventy Five”, “Blue”, “D”, new Integer(75), new Double(75.60)

446.               };

447.    data[75] = new Object [] {

448.                 “Seventy Six”, “Blue”, “D”, new Integer(76), new Double(76.60)

449.               };

450.    data[76] = new Object [] {

451.                 “Seventy Seven”, “Blue”, “D”, new Integer(77),

452.                 new Double(77.60)

453.               };

454.    data[77] = new Object [] {

455.                 “Seventy Eight”, “Blue”, “D”, new Integer(78),

456.                 new Double(78.60)

457.               };

458.    data[78] = new Object [] {

459.                 “Seventy Nine”, “Blue”, “D”, new Integer(79), new Double(79.60)

460.               };

461.    data[79] = new Object [] {

462.                 “Eighty”, “Blue”, “D”, new Integer(80), new Double(80.60)

463.               };

464.    data[80] = new Object [] {

465.                 “Eighty One”, “Blue”, “D”, new Integer(81), new Double(81.60)

466.               };

467.    data[81] = new Object [] {

468.                 “Eighty Two”, “Blue”, “D”, new Integer(82), new Double(82.60)

469.               };

470.    data[82] = new Object [] {

471.                 “Eighty Three”, “Blue”, “D”, new Integer(83), new Double(83.60)

472.               };

473.    data[83] = new Object [] {

474.                 “Eighty Four”, “Blue”, “D”, new Integer(84), new Double(84.60)

475.               };

476.    data[84] = new Object [] {

477.                 “Eighty Five”, “Blue”, “D”, new Integer(85), new Double(85.60)

478.               };

479.    data[85] = new Object [] {

480.                 “Eighty Six”, “Blue”, “D”, new Integer(86), new Double(86.60)

481.               };

482.    data[86] = new Object [] {

483.                 “Eighty Seven”, “Blue”, “D”, new Integer(87), new Double(87.60)

484.               };

485.    data[87] = new Object [] {

486.                 “Eighty Eight”, “Blue”, “D”, new Integer(88), new Double(88.60)

487.               };

488.    data[88] = new Object [] {

489.                 “Eighty Nine”, “Blue”, “D”, new Integer(89), new Double(89.60)

490.               };

491.    data[89] = new Object [] {

492.                 “Ninety”, “Blue”, “D”, new Integer(90), new Double(90.60)

493.               };

494.    data[90] = new Object [] {

495.                 “Ninety One”, “Blue”, “D”, new Integer(91), new Double(91.60)

496.               };

497.    data[91] = new Object [] {

498.                 “Ninety Two”, “Blue”, “D”, new Integer(92), new Double(92.60)

499.               };

500.    data[92] = new Object [] {

501.                 “Ninety Three”, “Blue”, “D”, new Integer(93), new Double(93.60)

502.               };

503.    data[93] = new Object [] {

504.                 “Ninety Four”, “Blue”, “D”, new Integer(94), new Double(94.60)

505.               };

506.    data[94] = new Object [] {

507.                 “Ninety Five”, “Blue”, “D”, new Integer(95), new Double(95.60)

508.               };

509.    data[95] = new Object [] {

510.                 “Ninety Six”, “Blue”, “D”, new Integer(96), new Double(96.60)

511.               };

512.    data[96] = new Object [] {

513.                 “Ninety Seven”, “Blue”, “D”, new Integer(97), new Double(97.60)

514.               };

515.    data[97] = new Object [] {

516.                 “Ninety Eight”, “Blue”, “D”, new Integer(98), new Double(98.60)

517.               };

518.    data[98] = new Object [] {

519.                 “Ninety Nine”, “Blue”, “D”, new Integer(99), new Double(99.60)

520.               };

521.    data[99] = new Object [] {

522.                 “One Hundred”, “Blue”, “D”, new Integer(100),

523.                 new Double(100.60)

524.               };

525.    data[100] = new Object [] {

526.                  “One Hundred and One”, “Blue”, “D”, new Integer(101),

527.                  new Double(101.60)

528.                };

529.    data[101] = new Object [] {

530.                  “One Hundred and Two”, “Blue”, “D”, new Integer(102),

531.                  new Double(102.60)

532.                };

533.    data[102] = new Object [] {

534.                  “One Hundred and Three”, “Blue”, “D”, new Integer(103),

535.                  new Double(103.60)

536.                };

537.    data[103] = new Object [] {

538.                  “One Hundred and Four”, “Blue”, “D”, new Integer(104),

539.                  new Double(104.60)

540.                };

541.    data[104] = new Object [] {

542.                  “One Hundred and Five”, “Blue”, “D”, new Integer(105),

543.                  new Double(105.60)

544.                };

545.    data[105] = new Object [] {

546.                  “One Hundred and Six”, “Blue”, “D”, new Integer(106),

547.                  new Double(106.60)

548.                };

549.    data[106] = new Object [] {

550.                  “One Hundred and Seven”, “Blue”, “D”, new Integer(107),

551.                  new Double(107.60)

552.                };

553.    data[107] = new Object [] {

554.                  “One Hundred and Eight”, “Blue”, “D”, new Integer(108),

555.                  new Double(108.60)

556.                };

557.    data[108] = new Object [] {

558.                  “One Hundred and Nine”, “Blue”, “D”, new Integer(109),

559.                  new Double(109.60)

560.                };

561.    data[109] = new Object [] {

562.                  “One Hundred and Ten”, “Blue”, “D”, new Integer(110),

563.                  new Double(110.60)

564.                };

565.    data[110] = new Object [] {

566.                  “One Hundred and Eleven”, “Blue”, “D”, new Integer(111),

567.                  new Double(111.60)

568.                };

569.    data[111] = new Object [] {

570.                  “One Hundred and Twelve”, “Blue”, “D”, new Integer(112),

571.                  new Double(112.60)

572.                };

573.    data[112] = new Object [] {

574.                  “One Hundred and Thirteen”, “Blue”, “D”, new Integer(113),

575.                  new Double(113.60)

576.                };

577.    data[113] = new Object [] {

578.                  “One Hundred and Fourteen”, “Blue”, “D”, new Integer(114),

579.                  new Double(114.60)

580.                };

581.    data[114] = new Object [] {

582.                  “One Hundred and Fifteen”, “Blue”, “D”, new Integer(115),

583.                  new Double(115.60)

584.                };

585.    data[115] = new Object [] {

586.                  “One Hundred and Sixteen”, “Blue”, “D”, new Integer(116),

587.                  new Double(116.60)

588.                };

589.    data[116] = new Object [] {

590.                  “One Hundred and Seventeen”, “Blue”, “D”, new Integer(117),

591.                  new Double(117.60)

592.                };

593.    data[117] = new Object [] {

594.                  “One Hundred and Eighteen”, “Blue”, “D”, new Integer(118),

595.                  new Double(118.60)

596.                };

597.    data[118] = new Object [] {

598.                  “One Hundred and Nineteen”, “Blue”, “D”, new Integer(119),

599.                  new Double(119.60)

600.                };

601.    data[119] = new Object [] {

602.                  “One Hundred and Twenty”, “Blue”, “D”, new Integer(120),

603.                  new Double(120.60)

604.                };

605.

606.    Object [] names = { “???”, “COLOR”, “LETTER”, “INTEGER”, “DOUBLE” };

607.

608.    String filename = “f:\\exporttest.xls”;

609.    ExportXlsUtil test = new ExportXlsUtil();

610.    try{

611.      test.exportTableToXls(data, names, filename);

612.    }catch(IOException e) {

613.      e.printStackTrace();

614.    }

615.  }

616.}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值