Trying to read CSV and copy or save to .xlsx format. But the column headers are not copying to .xlsx when I use write range activity

r0818 · April 20, 2023, 2:43am

need help how to copy .csv file to .xlsx file format including headers.

Yoichi · April 20, 2023, 2:49am

HI,

Can you try to turn on AddHeaders property?

Regards,

r0818 · April 20, 2023, 2:56am

ok, let me try. should I add write range workbook and read csv activities inside excel scope?

Yoichi · April 20, 2023, 2:59am

No. WriteCSV and WriteRangeWorkbook work without ExcelApplciationScope or UseExcelFile.

Regards,