Thank you too

Thank you!

My pleasure!

yes, it can be.you can use the macro in excel, after loading the data, use the macro for formatting manually.

Welcome.

You are welcome

You're welcome!

Most Welcome.

Please see carefully, for multiple excel file use for each loop container , you can check from this this frame kzbin.info/www/bejne/fXLZnYiOZruVZ5Y and you will get your answer

thanks.

Most Welcome.

you can use Conditional Split in SSIS, Step 1: Take the excel data source and configure it data connection. Step 2: Take the Conditional Split and use in condition emp_location == "Delhi" for case 1 and emp_location == "Mumbai" for case 2. Step 3: take two oledb , one for panjab and other for delhi and map it. and run the project and data will transfer into two different table.

Thanks and welcome

You're welcome!

go.microsoft.com/fwlink/?LinkId=532606&clcid=0x409

most welcome.

thanks. kzbin.info/www/bejne/a5rTpp1-p7mfbpI

Thank you too!

Most welcome 😊

You're welcome

Thanks for the info!

kzbin.info/www/bejne/np3LiGmbi9J5ask

thanks

Function to save the data table( which are converted to json to data table) in excel: public static void Save_data_table_to_excel(DataTable dt) { int intHeaderLength = 3; int intColumn = 0; int intRow = 0; string Work_sheet_name = "Employee daetails"; string Report_Type = "Details"; System.Reflection.Missing Default = System.Reflection.Missing.Value; //create the excel file //string FilePath = @"\\Excel" + DateTime.Now.ToString().Replace(":", "_" + ".xlsx"); string FilePath = @"F:\Project-Library\cSharp\Export_to_Excel_data_table\Export_to_Excel_data_table\Export_to_Excel_data_table\bin\Debug\Employee.xls"; Microsoft.Office.Interop.Excel.Application excel; Microsoft.Office.Interop.Excel.Workbook excelworkbook; Microsoft.Office.Interop.Excel.Worksheet excelsheet; Microsoft.Office.Interop.Excel.Range excelCellRange; try { //start the application excel = new Microsoft.Office.Interop.Excel.Application(); if (excel == null) { Console.WriteLine("getting null values"); } //for making excel visiable excel.Visible = false; excel.DisplayAlerts = false; // creation a new work book excelworkbook = excel.Workbooks.Add(Type.Missing); //excelsheet excelsheet = (Microsoft.Office.Interop.Excel.Worksheet)excelworkbook.ActiveSheet; excelsheet.Name = Work_sheet_name; excelsheet.Cells[1, 2] = Report_Type; excelsheet.Cells[1, 2] = "Date :" + DateTime.Now.ToShortDateString().ToString(); // loop through each row and add the value to our sheet int rowcount = 2; foreach (DataRow datarow in dt.Rows) { rowcount += 1; for (int i = 1; i < dt.Columns.Count; i++) { // on first iteration we add column header excelsheet.Cells[2, i] = dt.Columns[i - 1].ColumnName; excelsheet.Cells.Font.Color = System.Drawing.Color.Black; excelsheet.Cells[rowcount, i] = datarow[i - 1].ToString(); // for alternate rows if (rowcount > 3) { if (i == dt.Columns.Count) { if (rowcount % 2 == 0) { excelCellRange = excelsheet.Range[excelsheet.Cells[rowcount, 1], excelsheet.Cells[rowcount, dt.Columns.Count]]; } } } } // now resize the columns excelCellRange = excelsheet.Range[excelsheet.Cells[1, 1], excelsheet.Cells[rowcount, dt.Columns.Count]]; excelCellRange.EntireColumn.AutoFit(); } //now save the work book and exit the ecel excelworkbook.SaveAs(FilePath); excelworkbook.Close(); excel.Quit(); // } } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadKey(); } finally { excelsheet = null; excelCellRange = null; excelworkbook = null; } }

Most welcome!

Welcome

Welcome

kzbin.info/www/bejne/iWOyqqGngK6rgMU

In the description, you can check out.