打开现有的:
using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
/// <summary>
///
/// </summary>
class ExportClass
{
public static void exportFile()
{
str tmpfile;
str value;
CustTable custTable;
FileInfo templateFile;
ExcelRange cell;
ExcelWorksheet cells;
MemoryStream memoryStream = new MemoryStream();
int currentRow = 3;
;
//Get Resource temPlate
tmpfile = '文件路径';
//Convert to an IO stream
templateFile = new System.IO.FileInfo(tmpfile);
using (ExcelPackage filepackage = new ExcelPackage(templateFile))
{
// 获取模板第2个sheet
cells = filepackage.Workbook.Worksheets.get_Item(2);
// 获取内存流
memoryStream = filepackage.Stream;
//set value
cell = cells.get_Cells().get_Item(1, 2);
cell.value = '1';
cell = cells.get_Cells().get_Item(1, 4);
cell.value = '2';
cell = cells.get_Cells().get_Item(1, 6);
cell.value = '3';
filepackage.Save();
file::SendFileToUser(memoryStream,'ExportExcelFile.xlsx');
}
}
}
创建新的
using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
class SRWriteToExcel
{
public static void main(Args _args)
{
CustTable custTable;
MemoryStream memoryStream = new MemoryStream();
using (var package = new ExcelPackage(memoryStream))
{
var currentRow = 1;
var worksheets = package.get_Workbook().get_Worksheets();
var CustTableWorksheet = worksheets.Add("Export");
var cells = CustTableWorksheet.get_Cells();
OfficeOpenXml.ExcelRange cell = cells.get_Item(currentRow, 1);
System.String value = "Account Number";
cell.set_Value(value);
cell = null;
value = "Currency";
cell = cells.get_Item(currentRow, 2);
cell.set_Value(value);
while select CustTable
{
currentRow ++;
cell = null;
cell = cells.get_Item(currentRow, 1);
cell.set_Value(CustTable.AccountNum);
cell = null;
cell = cells.get_Item(currentRow, 2);
cell.set_Value(CustTable.Currency);
}
package.Save();
file::SendFileToUser(memoryStream, 'Test.xlsx');
}
}
}