public static void SaveAsExcel(string sCSVFile, string sExcelFile)
{
Workbooks excelWorkBooks = null;
Workbook excelWorkBook = null;
Application app = new Application();
app.Visible = false;
app.DisplayAlerts = false;
excelWorkBooks = app.Workbooks;
excelWorkBook = ((Workbook)excelWorkBooks.Open(sCSVFile, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value));
log.InfoFormat("excel path is :{0}", sExcelFile);
excelWorkBook.SaveAs(sExcelFile, XlFileFormat.xlAddIn8, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
excelWorkBook.Close();
app.Quit();
}
//private string GetDescription(int sampleID)
//{
// int sampleIndex = sampleID - 1;
// int colIndex = sampleIndex / 8;
// int rowIndex = sampleIndex - colIndex * 8;
// return string.Format("{0}{1:D2}", (char)('A' + rowIndex), colIndex + 1);
//}
private void SaveAsCSV(List<string> sheetPaths)
{
Application app = new Application();
app.Visible = false;
app.DisplayAlerts = false;
foreach (string sheetPath in sheetPaths)
{
string sWithoutSuffix = "";
int pos = sheetPath.IndexOf(".xls");
if (pos == -1)
throw new Exception("Cannot find xls in file name!");
sWithoutSuffix = sheetPath.Substring(0, pos);
string sCSVFile = sWithoutSuffix + ".csv";
if (File.Exists(sCSVFile))
continue;
sCSVFile = sCSVFile.Replace("\\\\", "\\");
Workbook wbWorkbook = app.Workbooks.Open(sheetPath);
wbWorkbook.SaveAs(sCSVFile, XlFileFormat.xlCSV);
wbWorkbook.Close();
Console.WriteLine(sCSVFile);
}
app.Quit();
}
