【FAQ】Excel组件Spire.XLS 技术FAQ汇总 | 附下载

小鱼儿 2022-06-07 11:11 387阅读 0赞

![图片1][1]

[点击下载Spire.XLS][Spire.XLS]

**Q.如何将图像添加到Excel？**

--------------------

A:请调用方法添加将图像添加到Excel文件的工作表中。 全部代码：

Workbook workbook = new Workbook();
    Worksheet sheet = workbook.Worksheets[0];
    
    //insert the picture day.jpg into the sheet and place it in the cell "B3"
    sheet.Pictures.Add(3, 2, "day.jpg");
    workbook.SaveToFile("result.xlsx");

**Q.如何将新行插入Excel文件的工作表？**

--------------------

A:请调用InsertRow方法将新行添加到Excel文件的工作表中。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    Worksheet sheet = workbook.Worksheets[0];
    
    //add a new row in the third row
    sheet.InsertRow(3);
    workbook.SaveToFile("result.xlsx");

**Q.如何在XLS中设置打印区域？**

--------------------

A:可以设置工作表的PrintArea属性。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    Worksheet sheet = workbook.Worksheets[0];
    
    //set print area from cell "B2" to cell "F8"
    sheet.PageSetup.PrintArea = "B2:F8";
    workbook.SaveToFile("result.xlsx");

**Q.如何复制单元格格式？**

--------------------

A:[Spire.XLS][Spire.XLS 1]为您提供了一种称为“复制”的格式来复制单元格的方法。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    Worksheet sheet1 = workbook.Worksheets[0];
    Worksheet sheet3 = workbook.Worksheets[2];
    
    //copy cell "B2" in sheet1 to cell "C6" in sheet3
    sheet1.Range[3, 2].Copy(sheet3.Range[6,3]);
    workbook.SaveToFile("result.xlsx");

**Q.如何将XLS转换为PDF？**

--------------------

A:首先，您需要将Spire.Pdf和Spire.Common的参考添加到您的项目中。 然后创建一个PdfDocument和一个PDF转换器对象的实例。 最后，调用转换方法转换XLS到PDF。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    PdfConverter pdfConverter = new PdfConverter(workbook);
    PdfDocument pdfDocument = new PdfDocument();
    
    //settings of result PDF docement
    pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape;
    pdfDocument.PageSettings.Width = 970;
    pdfDocument.PageSettings.Height = 850;
    PdfConverterSettings settings = new PdfConverterSettings();
    settings.TemplateDocument = pdfDocument;
    
    //convert XLS to PDF using PdfConverter
    pdfDocument = pdfConverter.Convert(settings);
    pdfDocument.SaveToFile("result.pdf");

**Q.如何在XLS中合并单元格？**

--------------------

A:[Spire.XLS][Spire.XLS 1]为您提供了一种称为合并的方法来合并XLS中的单元格。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    Worksheet sheet = workbook.Worksheets[0];
    
    //merges cells "B3" "B4"
    sheet.Range["B3:B4"].Merge();
    workbook.SaveToFile("result.xlsx");

**Q.如何重新排列XLS文件中的工作表？**

--------------------

A[:Spire.XLS][Spire.XLS 1]为您提供了一个称为MoveWorksheet的方法来重新排列XLS文件中的工作表？ 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    Worksheet sheet = workbook.Worksheets[3];
    
    //move the fourth worksheet sheet to the first position of the worksheets
    sheet.MoveWorksheet(0);
    workbook.SaveToFile("result.xlsx");

**Q.如何删除excel工作表中的列？**

--------------------

A:Spire.XLS为您提供一个名为DeleteColumn的方法来删除列。 此方法立即影响工作表收集的顺序。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    
    Worksheet sheet = workbook.Worksheets[1];
    //delete the second column
    sheet.DeleteColumn(2);
    
    //delete the fourth column
    sheet.DeleteColumn(3);
    workbook.SaveToFile("result.xlsx");

**Q.如何在XLS中指定范围内设置数字格式？**

--------------------

A:您可以使用目标单元格的NumberFormat格式来设置cellrange的NumberValue。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample.xlsx");
    Worksheet sheet = workbook.Worksheets[0];
    
    //set number format in specified range
    sheet.Range[2, 2, 6, 6].NumberFormat = "$#,##0.00";
    sheet.Range["C3"].NumberValue = 3240.689;
    sheet.Range["D4"].NumberValue = 5230.123;
    workbook.SaveToFile("result.xlsx");

**Q.如何向单元格添加公式？**

--------------------

A:只需设置单元格的公式属性即可添加公式。 全部代码：

Workbook workbook = new Workbook();
    Worksheet worksheet = workbook.Worksheets[0];
    
    //add formula =IF(H7>0,(IF(F7 > 0,(H7-F7)/F7,"""")),"""") to cell "J7"
    string formula = @"=IF(H7>0,(IF(F7 > 0,(H7-F7)/F7,"""")),"""")";
    worksheet.Range["J7"].Formula = formula;
    worksheet.Range["F7"].NumberValue = 5;
    worksheet.Range["H7"].NumberValue = 4;
    workbook.SaveToFile("result.xlsx", ExcelVersion.Version2007);

**Q.如何合并多个工作簿？**

--------------------

A:[Spire.XLS][Spire.XLS 1]为您提供了一个名为AddCopy的方法来合并Excel文件。 全部代码：

Workbook workbook = new Workbook();
    workbook.LoadFromFile("sample1.xlsx");
    Workbook workbookDest = new Workbook();
    workbookDest.LoadFromFile("sample2.xlsx");
    
    //merge workbook with workbookDest
    workbookDest.Worksheets.AddCopy(workbook.Worksheets);
    workbookDest.SaveToFile("result.xlsx");

[1]: /images/20220607/f732fb1ca9f04ea68a2094a75a8ad370.png
[Spire.XLS]: https://www.evget.com/product/3371/download
[Spire.XLS 1]: https://www.evget.com/product/3371