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"); } }