private static void Main(string[] args) { string directoryWithExcelFiles; if (args.Length == 0) { // If no directory path is passed as argument, consider the current process directory directoryWithExcelFiles = Directory.GetCurrentDirectory(); } else { directoryWithExcelFiles = Path.GetFullPath(args[0]); } var excelFilesToConvert = Directory.EnumerateFiles(directoryWithExcelFiles, "*.xls"); var excelInteropExcelToPdfConverter = new ExcelInteropExcelToPdfConverter(); try { excelInteropExcelToPdfConverter.ConvertToPdf(excelFilesToConvert); } catch (Exception ex) { Console.Error.WriteLine($"Something went wrong: {ex.Message}"); Environment.ExitCode = -1; return; } Console.WriteLine("Operation completed"); }
private void btnConvert_Click(object sender, EventArgs e) { string directoryWithExcelFiles; string sourceFolder = tbSource.Text; string destinationFolder = tbDestination.Text; string sMsg = @"Sit back and Relax, Your Excel(s) are being Converted to PDF..."; Log.Write($"Source : {sourceFolder}"); Log.Write($"Destination : {destinationFolder}"); tbDestination.Hide(); tbSource.Hide(); btnConvert.Hide(); btnSource.Hide(); btnDestination.Hide(); lblMsg.Text = sMsg; lblMsg.Show(); if (sourceFolder.Length == 0) { // If no directory path is passed as argument, consider the current process directory //directoryWithExcelFiles = Directory.GetCurrentDirectory(); MessageBox.Show("Select Source Folder.", "Select Folder"); } else { directoryWithExcelFiles = Path.GetFullPath(sourceFolder); if (destinationFolder.Length == 0) { destinationFolder = sourceFolder; } var excelFilesToConvert = Directory.EnumerateFiles(directoryWithExcelFiles, "*.xls"); Log.Write($"" + $"Files to Convert :" + $"================"); var i = 1; foreach (var sPath in excelFilesToConvert) { Log.Write($"File ({i}) : {sPath.ToString()}"); i++; } var excelInteropExcelToPdfConverter = new ExcelInteropExcelToPdfConverter(); try { excelInteropExcelToPdfConverter.ConvertToPdf(excelFilesToConvert, destinationFolder); } catch (Exception ex) { MessageBox.Show($"Something went wrong: {ex.Message}"); Log.Write($"Something went wrong: {ex.Message}"); Environment.ExitCode = -1; tbDestination.Show(); tbSource.Show(); btnConvert.Show(); btnSource.Show(); btnDestination.Show(); lblMsg.Text = sMsg; lblMsg.Hide(); return; } } MessageBox.Show("Operation completed"); }