Can RadGridView support Export to Excel in Traditional-Chinese chars (in Office2007 Traditional-Chinese)?
I try these scripts, but the Chinese Chars cannot show(I only see the "?" char),
ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
exporter.SheetMaxRows = ExcelMaxRows._65535;
exporter.ExportVisualSettings = true;
string fileName = "ExportedData.xls";
exporter.RunExport(fileName);
thanks for your kindly help.
Edwin
below is some sample data from the generated excel file:
StorerKey | Type | Company | VAT | Address1 | Address2 | Zip | Contact1 | Contact2 | Phone1 | Phone2 | Fax1 | Fax2 | Email1 | Email2 | MemberID | MemberAddDate | ShortCode | ShortName | Phone | Contact3 | Phone3 | Http | TransactionCount | TransactionAmount | AvailableAmount | LastTransactionDate | DeliveryType | PayType | TaxType | isVendor | SaleMan | SaleMan1 | SaleMan2 | SaleMan3 | SaleManPhone1 | SaleManPhone2 | SaleManPhone3 | SaleManMobile1 | SaleManMobile2 | SaleManMobile3 | ContactMobile1 | ContactMobile2 | ContactMobile3 | CounterNO | SearchPath | ChannelStorer | GroupNo | InvTitleCode | BelongtoChannelStorer | ISCusLabel | PrePayAmount | DeadAmount | UseCase | Zone | SalesPermotePercent | InvoiceTitle | ZoneCombineType | IsInvoice | ZeroAmountNewTicketAllowed | SendShippingTKByPDFFtpFolder | SendShippingTKByPDFFtpFolderOn | SendShippingTKByPDFEMail | SendShippingTKByPDFFax | SendShippingTKByPrintOut | ShippingTKByPDFFtpFolder | CurrentMonth_NotPayedMoney | LastMonth_NotPayedMoney | Last2Month_NotPayedMoney | Over2Month_NotPayedMoney | SubZone | isPaperVendor | SafetyPriceState | SafetyPriceStateSystemInfoDate | SafetyPriceStateInfoMan | SafetyPriceStateInfoType | SafetyPriceStateInfoDate | isShipTKNotes | ManufactureCompanyKey | CompanyDetailKey | Contact1Email | Contact2Email | FTPDataEmail | AllowedAmount | isOPVendor | isSelfVendor | UniqueTicket | isCompanyInvoiceTitle | ClientSystem | Stop | SalesNotes | IssueMark | Notes1 | Notes2 |
0000000850 | 162 | ???(??:????) | ????????????1?3?14?3-1? | ????????????1?3?14?3-1? | 427 | ??? | ??? | 04-25336789 | 04-25336789 | 04-25316699 | B0624 | 37622 | ??? | 04-25336789 | 112 | 237222 | 3430 | 39989.29 | 14 | 3 | 0 | N | SA | SALE010 | SARA | SA | 0970-066321#6026 | 0932-533263 | 0932-533263 | \\dl360\f7\???\0000000850_???? | F7-??? | 00001 | Y | 0 | 0 | 0051 | 1.1 | B | Y | Y | N | N | N | N | Y | 0 | 0 | 0 | 0 | 0 | Y | 00001 | G0001 | -5000 | N | N | N | N |