Excel Write Range - Incorrect Header Encoding for Japanese

studio

#1

Our customer has oracle database, in which, they have table columns’ name in Japanese.

After query returned data into DataTable, we use Excel Application Scope, and Excel Write range to write this datatable into Excelfile.

The problem is:

  • Japanese within data is written correctly into Excel file
  • BUT, Japanese in column name is written as ???

We also used Write CSV, and specified Encoding as “shift_jis” but data is corrupt completely for both header, and data.

Please refer to attached image for more detail.

IncorrectExcelHeader