hi,
i have a mapping excel file containing external links to other ratesheet files (could be 1 ratesheet file or multiple ratesheet files). The mapping excel may have pivot table in other workbook.
When i open the ratesheet files and mapping file. The mapping files will refresh and pickup new data from ratesheet files.
and then save the mapping excel file to csv file.
Is there a way to accomplish that? I tried, but it does not work.
string rsFile = @"C:\Rates.xls";
string wsFile = @"C:\Worksheet Franklin.xls";
ExcelEngine excelEngine = new ExcelEngine();
IWorkbook rs = excelEngine.Excel.Workbooks.Open(@rsFile, ExcelOpenType.Automatic);
IWorkbook ws = excelEngine.Excel.Workbooks.Open(@wsFile, ExcelOpenType.Automatic);
ws.ActiveSheetIndex = 0;
ws.SaveAs(@wsFile.Replace(".xls", ".csv").Replace(".xlsx", ".csv"));
Thanks,
Minh