Java写一段导出表格的代码
时间: 2023-03-14 21:12:04 浏览: 50
代码如下:String fileName = "表格.xls";response.setHeader("Content-disposition", "attachment;filename=" + fileName);response.setContentType("application/msexcel;charset=UTF-8");ServletOutputStream out = response.getOutputStream();workbook.write(out);out.flush();out.close();
相关问题
Java写一段查数据库导出表格的代码
String url = "jdbc:mysql://localhost:3306/test";
String username = "username";
String password = "password";try {
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
String sql = "select * from table";
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
String[] colName = new String[colCount];
for(int i=0; i<colCount; i++) {
colName[i] = rsmd.getColumnName(i+1);
}
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
while(rs.next()) {
Map<String, Object> map = new HashMap<String, Object>();
for(int i=0; i<colCount; i++) {
map.put(colName[i], rs.getObject(i+1));
}
list.add(map);
}
ExportExcel.exportExcel(list, "表格名称");
rs.close();
stmt.close();
conn.close();
} catch(Exception e) {
e.printStackTrace();
}答:try {
String url = "jdbc:mysql://localhost:3306/test";
String username = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
String sql = "select * from table";
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
String[] colName = new String[colCount];
for(int i=0; i<colCount; i++) {
colName[i] = rsmd.getColumnName(i+1);
}
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
while(rs.next()) {
Map<String, Object> map = new HashMap<String, Object>();
for(int i=0; i<colCount; i++) {
map.put(colName[i], rs.getObject(i+1));
}
list.add(map);
}
ExportExcel.exportExcel(list, "表格名称");
rs.close();
stmt.close();
conn.close();
} catch(Exception e) {
e.printStackTrace();
}
Java怎么实现导出excel表格功能
要在Java中实现导出Excel表格功能,可以使用Apache POI库。以下是实现步骤:
1. 引入POI库的依赖
在Maven项目中,可以在pom.xml文件中添加以下依赖:
```xml
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
```
2. 创建Excel文档
```java
// 创建一个Excel文档
Workbook workbook = new XSSFWorkbook();
// 创建一个工作表
Sheet sheet = workbook.createSheet("Sheet1");
// 创建一行
Row row = sheet.createRow(0);
// 创建一个单元格
Cell cell = row.createCell(0);
// 设置单元格的值
cell.setCellValue("Hello, world!");
```
3. 保存Excel文档
```java
// 创建一个输出流
FileOutputStream outputStream = new FileOutputStream("example.xlsx");
// 将文档写入输出流
workbook.write(outputStream);
// 关闭输出流
outputStream.close();
```
完整代码如下:
```java
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileOutputStream;
import java.io.IOException;
public class ExcelExporter {
public static void main(String[] args) throws IOException {
// 创建一个Excel文档
Workbook workbook = new XSSFWorkbook();
// 创建一个工作表
Sheet sheet = workbook.createSheet("Sheet1");
// 创建一行
Row row = sheet.createRow(0);
// 创建一个单元格
Cell cell = row.createCell(0);
// 设置单元格的值
cell.setCellValue("Hello, world!");
// 创建一个输出流
FileOutputStream outputStream = new FileOutputStream("example.xlsx");
// 将文档写入输出流
workbook.write(outputStream);
// 关闭输出流
outputStream.close();
}
}
```
这段代码会在项目根目录下生成一个名为example.xlsx的Excel文档,其中包含一个名为Sheet1的工作表,第一行第一列的单元格中的值为"Hello, world!"。