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 |   |   |   |   |   |   |
DialogResult mr = new DialogResult(); |
mr = MessageBox.Show("Are U Sure?"); |
if (mr == DialogResult.OK) |
{ |
Telerik.WinControls.UI.GridViewDataRowInfo Row; |
int RCount = GridHdr.SelectedRows.Count(); |
for (int I = RCount - 1; I > -1; I--) |
{ |
Row = (Telerik.WinControls.UI.GridViewDataRowInfo)GridHdr.SelectedRows[I]; |
Row.Delete(); |
BindingSourceHdr.EndEdit(); |
AdapterHdr.Update(dBDataSet); |
} |
} |
foreach(GridViewDataRowInfo Row in GridHdr.SelectedRows) |
{ |
Row.Delete(); BindingSourceHdr.EndEdit(); AdapterHdr.Update(dBDataSet); |
} |
I use an unbound radgridview. After initialization of the columns i have an empty radgridview.
When i now call radgridview1.MasterGridViewTemplate.BestFitColumns( );
then the column header is ignored in the calculation of the best size for the columns and all columns are shrunken to a few pixels.
Kind Regards,
Ramius
CSUserControl itemControl; |
if (typeof(CSUserControl).IsAssignableFrom(ucType)) |
{ |
itemControl = (CSUserControl) Activator.CreateInstance(ucType, parameterList); |
} |
else |
{ |
UserControl item = (UserControl)Activator.CreateInstance(ucType, parameterList); |
itemControl = new CSUserControl(); |
itemControl.Controls.Add(item); |
item.Dock = DockStyle.Fill; |
} |
Size size = itemControl.Size; |
//Hook up events |
itemControl.WindowChangeRequested += documentPane_WindowChangeRequested; |
itemControl.WindowOpenRequested += documentPane_WindowOpenRequested; |
itemControl.WindowCloseRequested += documentPane_WindowCloseRequested; |
itemControl.AutoScroll = true; |
HostWindow host; |
if (dockPosition == DockPosition.Fill) |
{ |
host = _dock.DockControl(itemControl, dockPosition, DockType.Document); |
} |
else |
{ |
host = _dock.DockControl(itemControl, dockPosition); |
} |
host.Text = documentName; |
host.Name = documentName; |
host.CloseAction = DockWindowCloseAction.CloseAndDispose; |
host.AutoScroll = true; |
host.TabStrip.AutoScroll = true; |
//host.TabStrip.MinimumSize = itemControl.MinimumSize; |
//host.MinimumSize = itemControl.MinimumSize; |
DockTabStrip strip = (DockTabStrip)host.TabStrip; |
strip.SizeInfo.AbsoluteSize = size; |
_dock.ActivateWindow(host); |