Aspose.Cells.dll
public void exceltoimg()
{
Workbook book = new Workbook("E:\\1.xls");
Worksheet sheet = book.Worksheets[0];
Cells cells = sheet.Cells;
sheets.AutoFitRows();//自动适应列
for (int j = 0; j < cells.Rows.Count; j++)
{
for (int i = 0; i < cells.Columns.Count; i++)
{
Cell cell = cells.GetCell(j,i);
Style style = cell.GetStyle();
style.HorizontalAlignment = TextAlignmentType.Center;
style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.TopBorder].Color = Color.Black;
style.IsTextWrapped = true;//文字太多自动换行
if (j == cells.Rows.Count - 1)
{
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.BottomBorder].Color = Color.Black;
}
style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.LeftBorder].Color = Color.Black;
if (i == cells.Columns.Count - 1)
{
style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.RightBorder].Color = Color.Black;
}
cell.SetStyle(style);
}
}
sheet.PageSetup.LeftMargin = 0;
sheet.PageSetup.RightMargin = 0;
sheet.PageSetup.BottomMargin = 0;
sheet.PageSetup.TopMargin = 0;
AutoFitterOptions options = new AutoFitterOptions() { AutoFitMergedCells = true };
sheet.AutoFitRows();
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
imgOptions.OnePagePerSheet = true;
imgOptions.PrintingPage = PrintingPageType.IgnoreBlank;
SheetRender sr = new SheetRender(sheet, imgOptions);
sr.ToImage(0, "f:\\book.jpg");
}