摘要:
System.ArgumentException: Specified value has invalid Control characters.worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]).NumberFormat = "[DBNum1][$-804]G/通用格式";设置了单元格格式为小写中文。1~9没问题Excel.Range ran1 = worksheet.Columns.get_Range("H:H", Type.Missing);//或者.get_Range 阅读全文
摘要:
C#如何快速高效地导出10万以上的大量数据?string saveFileName = "";bool fileSaved = false;SaveFileDialog saveDialog = new SaveFileDialog();saveDialog.DefaultExt = "xls";saveDialog.Filter = "Excel文件|*.xls";saveDialog.FileName = "Sheet1";saveDialog.ShowDialog();saveFileName = saveD 阅读全文