Specify Encoding Format when Export DataTable to Excel with Open Xml SDK in c#

Question

I am just trying to export datatable as excel using open xml. Referred the below approach,

Export DataTable to Excel with Open Xml SDK in c#

But I couldn't specify the encoding format of the excel created. I want to save or create the excecl with UTF-Encoding-8 format.

Can some one help on how could the formatting specificed using Open XML

FortyTwo · Accepted Answer · 2017-06-06 22:55:06Z

2

To save an Excel file with UTF-Encoding-8 Format you need to specify the encoding format under Tools -> Web Options -> Encoding while saving the excel file.

With OpenXML you need to create a new WebPublishing and add it to Workbook.

WebPublishing webPublishing1 = new WebPublishing(){ AllowPng = true, TargetScreenSize = TargetScreenSizeValues.Sz1024x768, CodePage = (UInt32Value)65001U };
workbook1.Append(webPublishing1);
//Where workbook1 is WorkbookPart.Workbook

answered Jun 6, 2017 at 22:55

FortyTwo

2,6593 gold badges26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Specify Encoding Format when Export DataTable to Excel with Open Xml SDK in c#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related