public static void RenderToExcel()
{
/* FileStream fs = null;
if (!File.Exists("test.xlsx"))
{
FileStream fs = new FileStream(@"D:\test.xlsx", FileMode.Create, FileAccess.Write);
}
else
{ */
FileStream fs =File.Open(@"D:\test.xlsx", FileMode.Open, FileAccess.ReadWrite);
// using (FileStream fs = new FileStream(@"D:\test.xlsx", FileMode.Create, FileAccess.Write))
// {
IWorkbook workbook = new XSSFWorkbook(fs);
{
XSSFSheet sheet = workbook.GetSheetAt(0) as XSSFSheet;
{
XSSFRow headerRow = sheet.GetRow(0) as XSSFRow;
XSSFCell cell = headerRow.GetCell(1) as XSSFCell;
Console.WriteLine("cell={0}",cell);
cell.SetCellValue("lanfang");
fs.Close();
}
{
/* FileStream fs = null;
if (!File.Exists("test.xlsx"))
{
FileStream fs = new FileStream(@"D:\test.xlsx", FileMode.Create, FileAccess.Write);
}
else
{ */
FileStream fs =File.Open(@"D:\test.xlsx", FileMode.Open, FileAccess.ReadWrite);
// using (FileStream fs = new FileStream(@"D:\test.xlsx", FileMode.Create, FileAccess.Write))
// {
IWorkbook workbook = new XSSFWorkbook(fs);
{
XSSFSheet sheet = workbook.GetSheetAt(0) as XSSFSheet;
{
XSSFRow headerRow = sheet.GetRow(0) as XSSFRow;
XSSFCell cell = headerRow.GetCell(1) as XSSFCell;
Console.WriteLine("cell={0}",cell);
cell.SetCellValue("lanfang");
fs.Close();
}