private void Run_Click_Click(object sender, EventArgs e)
{
if (sSelectedFolder != string.Empty && sSelectedFile != string.Empty)
{
Microsoft.Office.Interop.Excel.Application excelApp;
string fnTarget;
DateTime date;
string numOfPcs;
string clientCode;
string awb;
string awbEnding;
//fnTarget = "\\DPD TRACKING " + numOfPcs + " pcs_" + clientCode + "_" + awbEnding + ".xlsx";
//string fileTarget = "C:\\Users\\SBL-Warehouse\\Desktop\\ExcelBatchSave_Project" + fnTarget;
string fileTemplate = Application.StartupPath + "\\DPD TRACKING 123 pcs_SOSO_7777_template.xlsx";
excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wbTarget;
Microsoft.Office.Interop.Excel.Worksheet sh;
string fn;
SpreadsheetLight.SLDocument ss;
fn = sSelectedFile;
ss = new SpreadsheetLight.SLDocument(fn);
ss.SelectWorksheet("Sheet1");
//int rt;
//rt = 0;
Int32 row_count;
row_count = ss.GetWorksheetStatistics().EndRowIndex;
for (int ri = 2; ri <= row_count; ri++)
{
date = ss.GetCellValueAsDateTime(ri, 1);
clientCode = ss.GetCellValueAsString(ri, 2);
awb = ss.GetCellValueAsString(ri, 3);
awbEnding = awb.Substring(awb.Length - 4);
numOfPcs = ss.GetCellValueAsString(ri, 4);
wbTarget = excelApp.Workbooks.Open(fileTemplate);
sh = wbTarget.Worksheets["Sheet1"];
sh.Cells[1, 1] = date;
sh.Cells[1, 2] = numOfPcs + " pcs";
sh.Cells[1, 5] = awb;
fnTarget = "\\DPD TRACKING " + numOfPcs + " pcs_" + clientCode + "_" + awbEnding + ".xlsx";
string fileTarget = sSelectedFolder + fnTarget;
wbTarget.SaveAs(fileTarget);
wbTarget.Close(true);
excelApp.Quit();
}
string promptValue = Prompt.ShowDialog("Program finished successfully!", "Confirmation");
}
}
