CODEWITHSUNDEEP
c#.netexcelspreadsheetgear
Emmanuel Istace
Emmanuel Istace

Reputation: 1249

Spreadsheet Gear and DateTime Formatting

I'm trying to display date in the format dd/MM/yyyy in an excel file with the Spreadsheet Gear library, but the system and office looks like running an english localization.

I've already try to use the Cell.NumberFormat property and directly setting the DateTime object to the Cell.Value property, without success...

Do you have any idea on how to control the excel formating of a DateTime ?

Thanks

Upvotes: 3

Views: 3315

Answers (1)

Emmanuel Istace
Emmanuel Istace

Reputation: 1249

Ok, just found a solution.

When I create the WorkbookSet object, I can specify the CultureInfo (which can't be set after).

Example: 

SpreadsheetGear.Factory.GetWorkbookSet(CultureInfo.CurrentCulture);

Upvotes: 4

Related Questions