Функция:
Синтаксис:
Используется csharp
public void UpdateExcel2(string[] Value)
{
fs2 = new FileStream (filePath2,FileMode.OpenOrCreate,FileAccess.ReadWrite);
wk2 = new HSSFWorkbook(fs2);
sheet2 = wk2.GetSheetAt(0);
for (int j = 0; j <= sheet2.LastRowNum; j++)
{
row2 = sheet2.GetRow(j);
if (row2 != null)
{
for (int k = 1; k < row2.LastCellNum; k++)
{
cell2 = row2.CreateCell(1);
cell2.SetCellValue(Value[j]);
}
}
}
fs2.Close();
fs2 = File.OpenWrite(filePath2);
wk2.Write(fs2);
fs2.Close();
fs2.Dispose();
}
{
fs2 = new FileStream (filePath2,FileMode.OpenOrCreate,FileAccess.ReadWrite);
wk2 = new HSSFWorkbook(fs2);
sheet2 = wk2.GetSheetAt(0);
for (int j = 0; j <= sheet2.LastRowNum; j++)
{
row2 = sheet2.GetRow(j);
if (row2 != null)
{
for (int k = 1; k < row2.LastCellNum; k++)
{
cell2 = row2.CreateCell(1);
cell2.SetCellValue(Value[j]);
}
}
}
fs2.Close();
fs2 = File.OpenWrite(filePath2);
wk2.Write(fs2);
fs2.Close();
fs2.Dispose();
}