//-------
//新增XLS檔案
//-------
public void newFile()
{
sheetname = "sheet1";
Microsoft.Office.Interop.Excel.XlWBATemplate wba = Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet;
oexcel = new Microsoft.Office.Interop.Excel.Application();
obook = oexcel.Workbooks.Add(wba);
osheet = (Microsoft.Office.Interop.Excel.Worksheet)obook.Worksheets.get_Item(1);
sheetname = osheet.Name;
}
//-------
//新增XLS檔案
//-------
public void newFile(String[] SheetNames)
{
sheetname = "sheet1";
Microsoft.Office.Interop.Excel.XlWBATemplate wba = Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet;
oexcel = new Microsoft.Office.Interop.Excel.Application();
obook = oexcel.Workbooks.Add(wba);
osheet = (Microsoft.Office.Interop.Excel.Worksheet)obook.Worksheets[sheetname];
osheets = new Microsoft.Office.Interop.Excel.Worksheet[SheetNames.Length];
for (int i = 0; i < SheetNames.Length; i++)
{
osheets[i] = (Microsoft.Office.Interop.Excel.Worksheet)obook.Worksheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
osheets[i].Name = SheetNames[i];
}
}
//-------
//新增XLS檔案
//-------
public void newFile()
{
//MessageBox.Show("20151011");
//sheetname = "Sheet1";
Microsoft.Office.Interop.Excel.XlWBATemplate wba = Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet;
oexcel = new Microsoft.Office.Interop.Excel.Application();
obook = oexcel.Workbooks.Add(wba);
//osheet = (Microsoft.Office.Interop.Excel.Worksheet)obook.Worksheets[sheetname];
//for(int i=1 ;i< obook.Sheets.Count+1; i++)
//{
//osheet = (Microsoft.Office.Interop.Excel.Worksheet)obook.Worksheets.get_Item(i);
//MessageBox.Show(osheet.Name);
//}
if (obook.Sheets.Count < 1)
{
obook.Sheets.Add();
}
osheet = (Microsoft.Office.Interop.Excel.Worksheet)obook.Worksheets.get_Item(1);
sheetname = osheet.Name;
}
