C#å建Excelææ¡£ï¼ä¸é¢ç代ç éè¦æ·»å spire.doc.dll为ä¾èµ
//å建ä¸ä¸ªworkbookå®ä¾
Workbook wb = new Workbook();
//æ¸ é¤é»è®¤çå·¥ä½è¡¨
wb.Worksheets.Clear();
//æ·»å ä¸ä¸ªå·¥ä½è¡¨å¹¶æå®è¡¨å
Worksheet sheet = wb.Worksheets.Add("èå表");
//横åå并A1å°G1çåå æ ¼
sheet.Range["A1:G1"].Merge();
//åå ¥æ°æ®å°A1åå æ ¼ï¼è®¾ç½®æåæ ¼å¼å对é½æ¹å¼
sheet.Range["A1"].Value = "ç¯å®æ±½è½¦å ¬å¸åå·¥åºæ¬æ åµç»è®°è¡¨";
sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center;
sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center;
sheet.Range["A1"].Style.Font.IsBold = true;
sheet.Range["A1"].Style.Font.Size = 13F;
//设置第ä¸è¡è¡é«
sheet.Rows[0].RowHeight = 30F;
//å建ä¸ä¸ªDataTable
DataTable dt = new DataTable();
dt.Columns.Add("å§å");
dt.Columns.Add("æ§å«");
dt.Columns.Add("åºçæ¥æ");
dt.Columns.Add("å¦å");
dt.Columns.Add("èç³»çµè¯");
dt.Columns.Add("èå¡");
dt.Columns.Add("å·¥å·");
dt.Rows.Add("çä¼", "ç·", "1990å¹´2æ10æ¥", "æ¬ç§", "13524756854", "éå®","0054");
dt.Rows.Add("æå®", "ç·", "1985å¹´6æ8æ¥", "大ä¸", "13259863247", "éå®","0055");
dt.Rows.Add("é家佳", "女", "1989å¹´11æ25æ¥", "æ¬ç§", "13601540352", "éå®","0029");
dt.Rows.Add("æå¹³å®", "ç·", "1978å¹´4æ16æ¥", "ä¸ä¸", "13352014060", "ä¿å®","0036");
dt.Rows.Add("åé", "女", "1980å¹´1æ21æ¥", "æ¬ç§", "13635401489", "åºé¿","0010");
//å°DataTableæ°æ®åå ¥å·¥ä½è¡¨
sheet.InsertDataTable(dt, true, 2, 1, true);
//设置该åºåè¡é«
sheet.Range["A2:G7"].RowHeight = 15F;
//设置第ä¸åå第äºåå宽
sheet.Range["A2:G7"].Columns[2].ColumnWidth = 15F;
sheet.Range["A2:G7"].Columns[4].ColumnWidth = 15F;
//设置ç½æ ¼çº¿æ ·å¼åé¢è²
sheet.Range["A2:G7"].BorderAround(LineStyleType.Medium);
sheet.Range["A2:G7"].BorderInside(LineStyleType.Thin);
sheet.Range["A2:G2"].BorderAround(LineStyleType.Medium);
sheet.Range["A2:G7"].Borders.KnownColor = ExcelColors.Black;
//ä¿å为.xlsxæ件
wb.SaveToFile("å建Excel.xlsx", FileFormat.Version2013);