public static Bitmap GetImageSheet(byte[] filedata) { Bitmap bitmap = null; try { if (filedata == null) { return(null); } using (MemoryStream ms = new MemoryStream(filedata)) { Aspose.Cells.Workbook book = new Aspose.Cells.Workbook(ms); if (book.Worksheets.Count > 0) { Aspose.Cells.Worksheet sheet = book.Worksheets[0]; ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; imgOptions.OnePagePerSheet = true; imgOptions.IsCellAutoFit = false; SheetRender sr = new SheetRender(sheet, imgOptions); bitmap = sr.ToImage(0); } ms.Close(); } } catch (Exception ex) { } return(bitmap); }
public static void Run() { //Load sample Excel file containing the external resource e.g. linked image etc. Workbook wb = new Workbook(sourceDir + "sampleControlExternalResourcesUsingWorkbookSetting_StreamProvider.xlsx"); //Provide your implementation of IStreamProvider wb.Settings.StreamProvider = new SP(); //Access first worksheet Worksheet ws = wb.Worksheets[0]; //Specify image or print options, we need one page per sheet and png output ImageOrPrintOptions opts = new ImageOrPrintOptions(); opts.OnePagePerSheet = true; opts.ImageType = Drawing.ImageType.Png; //Create sheet render by passing required parameters SheetRender sr = new SheetRender(ws, opts); //Convert your entire worksheet into png image sr.ToImage(0, outputDir + "outputControlExternalResourcesUsingWorkbookSetting_StreamProvider.png"); Console.WriteLine("ControlExternalResourcesUsingWorkbookSetting_StreamProvider executed successfully."); }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); //Create workbook Workbook wb = new Workbook(); //Access first worksheet - it is empty sheet Worksheet ws = wb.Worksheets[0]; //Specify image or print options //Since the sheet is blank, we will set OutputBlankPageWhenNothingToPrint to true //So that empty page gets printed ImageOrPrintOptions opts = new ImageOrPrintOptions(); opts.ImageFormat = ImageFormat.Png; opts.OutputBlankPageWhenNothingToPrint = true; //Render empty sheet to png image SheetRender sr = new SheetRender(ws, opts); sr.ToImage(0, outputDir + "OutputBlankPageWhenNothingToPrint.png"); Console.WriteLine("OutputBlankPageWhenThereIsNothingToPrint executed successfully.\r\n"); }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Load an Excel file Workbook wb = new Workbook(sourceDir + "sampleSetPixelFormatRenderedImage.xlsx"); //Access first worksheet Worksheet ws = wb.Worksheets[0]; // Set the ImageOrPrintOptions with desired pixel format (24 bits per pixel) and image format type ImageOrPrintOptions opts = new ImageOrPrintOptions(); opts.PixelFormat = PixelFormat.Format24bppRgb; opts.ImageType = Drawing.ImageType.Tiff; // Instantiate SheetRender object based on the first worksheet SheetRender sr = new SheetRender(ws, opts); // Save the image (first page of the sheet) with the specified options sr.ToImage(0, outputDir + "outputSetPixelFormatRenderedImage.tiff"); Console.WriteLine("SetPixelFormatRenderedImage executed successfully."); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Open a template excel file Workbook book = new Workbook(dataDir + "Testbook.xlsx"); // Get the first worksheet. Worksheet sheet = book.Worksheets[0]; // Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); // Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); // Render the image for the sheet Bitmap bitmap = sr.ToImage(0); // Save the image file bitmap.Save(dataDir + "SheetImage.out.jpg"); // ExEnd:1 }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Open a template excel file Workbook book = new Workbook(sourceDir + "sampleSpecificPagesToImages.xlsx"); // Get the first worksheet. Worksheet sheet = book.Worksheets[0]; // Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); // Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Specify page index to be rendered int idxPage = 3; // Render the third image for the sheet Bitmap bitmap = sr.ToImage(idxPage); // Save the image file bitmap.Save(outputDir + "outputSpecificPagesToImage_" + (idxPage + 1) + ".jpg"); Console.WriteLine("SpecificPagesToImage executed successfully."); }
public static void Main(string[] args) { //ExStart:1 // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string filePath = dataDir + "Template.xlsx"; //Create a workbook object from the template file Workbook book = new Workbook(filePath); //Convert each worksheet into svg format in a single page. ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.SaveFormat = SaveFormat.SVG; imgOptions.OnePagePerSheet = true; //Convert each worksheet into svg format foreach (Worksheet sheet in book.Worksheets) { SheetRender sr = new SheetRender(sheet, imgOptions); for (int i = 0; i < sr.PageCount; i++) { //Output the worksheet into Svg image format sr.ToImage(i, filePath + sheet.Name + i + ".out.svg"); //ExEnd:1 } } }
public static Bitmap GetImageSheet(string filename) { Bitmap bitmap = null; try { if (string.IsNullOrEmpty(filename)) { return(null); } Aspose.Cells.Workbook book = new Aspose.Cells.Workbook(filename); if (book.Worksheets.Count > 0) { Aspose.Cells.Worksheet sheet = book.Worksheets[0]; ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; imgOptions.OnePagePerSheet = true; imgOptions.IsCellAutoFit = false; SheetRender sr = new SheetRender(sheet, imgOptions); bitmap = sr.ToImage(0); } } catch (Exception ex) { } return(bitmap); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Open a template excel file Workbook book = new Workbook(dataDir + "Testbook1.xlsx"); // Get the first worksheet. Worksheet sheet = book.Worksheets[0]; // Get the second worksheet. // Worksheet sheet = book.Worksheets[1]; // Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); // Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; // If you want entire sheet as a singe image imgOptions.OnePagePerSheet = true; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); // Render the image for the sheet Bitmap bitmap = sr.ToImage(0); // Save the image file bitmap.Save(dataDir + "SheetImage_out.jpg"); // ExEnd:1 }
public static void Main() { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); //Instantiate a workbook //Open the template file Workbook book = new Workbook(dataDir + "MyTestBook1.xlsx"); //Get the first worksheet Worksheet sheet = book.Worksheets[0]; //Specify your print area if you want //sheet.PageSetup.PrintArea = "A1:H8"; //To remove the white border around the image. sheet.PageSetup.LeftMargin = 0; sheet.PageSetup.RightMargin = 0; sheet.PageSetup.BottomMargin = 0; sheet.PageSetup.TopMargin = 0; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf; //Set only one page would be rendered for the image imgOptions.OnePagePerSheet = true; imgOptions.PrintingPage = PrintingPageType.IgnoreBlank; //Create the SheetRender object based on the sheet with its //ImageOrPrintOptions attributes SheetRender sr = new SheetRender(sheet, imgOptions); //Convert the image sr.ToImage(0, dataDir + "img_MyTestBook1.emf"); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Create a new Workbook object and //open a template Excel file. Workbook book = new Workbook(dataDir + "MyTestBook1.xls"); //Get the first worksheet. Worksheet sheet = book.Worksheets[0]; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); //Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Only one page for the whole sheet would be rendered imgOptions.OnePagePerSheet = true; //Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Render the image for the sheet Bitmap bitmap = sr.ToImage(0); //Save the image file specifying its image format. bitmap.Save(dataDir + "SheetImage.jpg"); // Display result, so that user knows the processing has finished. System.Console.WriteLine("Conversion to Image(s) completed."); }
public static void Main() { //ExStart:1 // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string filePath = dataDir + "aspose-sample.xlsx"; //Create workbook from source file. Workbook workbook = new Workbook(filePath); //Access the first worksheet Worksheet worksheet = workbook.Worksheets[0]; //Set the print area with your desired range worksheet.PageSetup.PrintArea = "E12:H16"; //Set all margins as 0 worksheet.PageSetup.LeftMargin = 0; worksheet.PageSetup.RightMargin = 0; worksheet.PageSetup.TopMargin = 0; worksheet.PageSetup.BottomMargin = 0; //Set OnePagePerSheet option as true ImageOrPrintOptions options = new ImageOrPrintOptions(); options.OnePagePerSheet = true; options.ImageFormat = ImageFormat.Jpeg; //Take the image of your worksheet SheetRender sr = new SheetRender(worksheet, options); sr.ToImage(0, dataDir + "output.out.jpg"); //ExEnd:1 }
public async void ExcelToImg(string ExcelPath) { Workbook book = new Workbook(ExcelPath); var list = book.Worksheets; int count = 0; foreach (var item in list) { count++; item.PageSetup.LeftMargin = 0; item.PageSetup.RightMargin = 0; item.PageSetup.BottomMargin = 0; item.PageSetup.TopMargin = 0; ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; imgOptions.OnePagePerSheet = true; imgOptions.PrintingPage = PrintingPageType.IgnoreBlank; SheetRender sr = new SheetRender(item, imgOptions); string filepath = $@"{Path.GetDirectoryName(ExcelPath)}\{item.Name}.jpg"; await Task.Run(() => sr.ToImage(0, filepath)); } label2.ForeColor = Color.Green; label2.Text = $"转换完成:图片已存放到{Path.GetDirectoryName(ExcelPath)}"; }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create workbook object from source file Workbook wb = new Workbook(dataDir + "aspose-sample.xlsx"); // Apply different image or print options var imgOption = new ImageOrPrintOptions(); imgOption.ImageFormat = ImageFormat.Png; imgOption.HorizontalResolution = 200; imgOption.VerticalResolution = 200; imgOption.OnePagePerSheet = true; // Apply transparency to the output image imgOption.Transparent = true; // Create image after apply image or print options var sr = new SheetRender(wb.Worksheets[0], imgOption); dataDir = dataDir + "output.png"; sr.ToImage(0, dataDir); // ExEnd:1 Console.WriteLine("\nProcess completed successfully.\nFile saved at " + dataDir); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); string filePath = dataDir + "Template.xlsx"; //Create a workbook object from the template file Workbook book = new Workbook(filePath); //Convert each worksheet into svg format in a single page. ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.SaveFormat = SaveFormat.SVG; imgOptions.OnePagePerSheet = true; //Convert each worksheet into svg format foreach (Worksheet sheet in book.Worksheets) { SheetRender sr = new SheetRender(sheet, imgOptions); for (int i = 0; i < sr.PageCount; i++) { //Output the worksheet into Svg image format sr.ToImage(i, filePath + sheet.Name + i + ".out.svg"); } } }
public static void Run() { // ExStart:1 //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); Workbook book = new Workbook(sourceDir + "sampleConvertWorksheetToImageByPage.xlsx"); Worksheet sheet = book.Worksheets[0]; Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.HorizontalResolution = 200; options.VerticalResolution = 200; options.ImageType = Drawing.ImageType.Tiff; // Sheet2Image By Page conversion SheetRender sr = new SheetRender(sheet, options); for (int j = 0; j < sr.PageCount; j++) { sr.ToImage(j, outputDir + "outputConvertWorksheetToImageByPage_" + (j + 1) + ".tif"); } // ExEnd:1 Console.WriteLine("ConvertWorksheetToImageByPage executed successfully."); }
public void ExcelToImg(string ExcelPath, string excelid) { testEntities db = new testEntities(); LicenseHelper.ModifyInMemory.ActivateMemoryPatching(); Workbook book = new Workbook(ExcelPath); var list = book.Worksheets; foreach (var item in list) { item.PageSetup.LeftMargin = 0; item.PageSetup.RightMargin = 0; item.PageSetup.BottomMargin = 0; item.PageSetup.TopMargin = 0; ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Png; imgOptions.OnePagePerSheet = true; imgOptions.PrintingPage = PrintingPageType.IgnoreBlank; SheetRender sr = new SheetRender(item, imgOptions); string guid = System.Guid.NewGuid().ToString(); string RelativePath = $@"/Upload/Sopimg/{guid}.png";//相对路径 string filepath = Server.MapPath(RelativePath); sr.ToImage(0, filepath); db.Sop_Img.Add(new Sop_Img() { imgid = excelid, imgpath = RelativePath }); db.SaveChanges(); } }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string filePath = dataDir+ "aspose-sample.xlsx"; // Create workbook from source file. Workbook workbook = new Workbook(filePath); // Access the first worksheet Worksheet worksheet = workbook.Worksheets[0]; // Set the print area with your desired range worksheet.PageSetup.PrintArea = "E12:H16"; // Set all margins as 0 worksheet.PageSetup.LeftMargin = 0; worksheet.PageSetup.RightMargin = 0; worksheet.PageSetup.TopMargin = 0; worksheet.PageSetup.BottomMargin = 0; // Set OnePagePerSheet option as true ImageOrPrintOptions options = new ImageOrPrintOptions(); options.OnePagePerSheet = true; options.ImageFormat = ImageFormat.Jpeg; // Take the image of your worksheet SheetRender sr = new SheetRender(worksheet, options); dataDir = dataDir+ "output.out.jpg"; sr.ToImage(0, dataDir); // ExEnd:1 Console.WriteLine("\nProcess completed successfully.\nFile saved at " + dataDir); }
public static void Run() { // ExStart:1 //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Create workbook object from source file Workbook wb = new Workbook(sourceDir + "sampleCreateTransparentImage.xlsx"); // Apply different image or print options var imgOption = new ImageOrPrintOptions(); imgOption.ImageType = Drawing.ImageType.Png; imgOption.HorizontalResolution = 200; imgOption.VerticalResolution = 200; imgOption.OnePagePerSheet = true; // Apply transparency to the output image imgOption.Transparent = true; // Create image after apply image or print options var sr = new SheetRender(wb.Worksheets[0], imgOption); sr.ToImage(0, outputDir + "outputCreateTransparentImage.png"); // ExEnd:1 Console.WriteLine("CreateTransparentImage executed successfully."); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string filePath = dataDir + "Template.xlsx"; //Create a workbook object from the template file Workbook book = new Workbook(filePath); //Convert each worksheet into svg format in a single page. ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.SaveFormat = SaveFormat.SVG; imgOptions.OnePagePerSheet = true; //Convert each worksheet into svg format foreach (Worksheet sheet in book.Worksheets) { SheetRender sr = new SheetRender(sheet, imgOptions); for (int i = 0; i < sr.PageCount; i++) { //Output the worksheet into Svg image format sr.ToImage(i, filePath + sheet.Name + i + ".out.svg"); } } }
public static void Main() { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); string filePath = dataDir+ "aspose-sample.xlsx"; //Create workbook from source file. Workbook workbook = new Workbook(filePath); //Access the first worksheet Worksheet worksheet = workbook.Worksheets[0]; //Set the print area with your desired range worksheet.PageSetup.PrintArea = "E12:H16"; //Set all margins as 0 worksheet.PageSetup.LeftMargin = 0; worksheet.PageSetup.RightMargin = 0; worksheet.PageSetup.TopMargin = 0; worksheet.PageSetup.BottomMargin = 0; //Set OnePagePerSheet option as true ImageOrPrintOptions options = new ImageOrPrintOptions(); options.OnePagePerSheet = true; options.ImageFormat = ImageFormat.Jpeg; //Take the image of your worksheet SheetRender sr = new SheetRender(worksheet, options); sr.ToImage(0, dataDir+ "output.jpg"); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create workbook object from source file Workbook wb = new Workbook(dataDir+ "aspose-sample.xlsx"); // Apply different image or print options var imgOption = new ImageOrPrintOptions(); imgOption.ImageFormat = ImageFormat.Png; imgOption.HorizontalResolution = 200; imgOption.VerticalResolution = 200; imgOption.OnePagePerSheet = true; // Apply transparency to the output image imgOption.Transparent = true; // Create image after apply image or print options var sr = new SheetRender(wb.Worksheets[0], imgOption); dataDir = dataDir+ "output.png"; sr.ToImage(0, dataDir); // ExEnd:1 Console.WriteLine("\nProcess completed successfully.\nFile saved at " + dataDir); }
public static void CreateStaticReport() { //Open template string path = System.Web.HttpContext.Current.Server.MapPath("~"); path = path.Substring(0, path.LastIndexOf("\\")); path += @"\designer\MyTestBook1.xls"; //Instantiate a new Workbook object. Workbook book = new Workbook(path); ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; Worksheet sheet = book.Worksheets[0]; SheetRender sheetRender = new SheetRender(sheet, imgOptions); //Create a memory stream object. MemoryStream memorystream = new MemoryStream(); //Convert worksheet to image. sheetRender.ToImage(0, memorystream); memorystream.Seek(0, SeekOrigin.Begin); //Set Response object to stream the image file. byte[] data = memorystream.ToArray(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ContentType = "image/jpeg"; HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=SheetImage.jpeg"); HttpContext.Current.Response.OutputStream.Write(data, 0, data.Length); //End response to avoid unneeded html after xls HttpContext.Current.Response.End(); }
/// <summary> /// 打印 /// </summary> private void printFile() { PageSetup pageSetup = DetailSheet.PageSetup; pageSetup.Orientation = PageOrientationType.Landscape; pageSetup.LeftMargin = 0.3; pageSetup.RightMargin = 0.5; pageSetup.BottomMargin = 0.5; pageSetup.PaperSize = PaperSizeType.Custom; pageSetup.PrintArea = "A1:H26"; //Apply different Image / Print options. Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.OnlyArea = true; // options.ImageFormat = ImageFormat.Jpeg; // options.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Set the Printing page property options.PrintingPage = PrintingPageType.IgnoreStyle; options.PrintWithStatusDialog = false; // options.Quality = 10; //Render the worksheet SheetRender sr = new SheetRender(DetailSheet, options); //System.Drawing.Printing.PrinterSettings printSettings = new System.Drawing.Printing.PrinterSettings(); //string strPrinterName = printSettings.PrinterName; ////send to printer //Image map = sr.ToImage(1); // sr.ToPrinter(strPrinterName); sr.ToImage(0, "sstest.Jpeg"); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Open a template Excel file. Workbook book = new Workbook(dataDir + "MyTestBook1.xls"); // Get the first worksheet. Worksheet sheet = book.Worksheets[0]; // Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); // Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; // Only one page for the whole sheet would be rendered imgOptions.OnePagePerSheet = true; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); // Render the image for the sheet Bitmap bitmap = sr.ToImage(0); // Save the image file specifying its image format. bitmap.Save(dataDir + "SheetImage.out.jpg"); // Display result, so that user knows the processing has finished. System.Console.WriteLine("Conversion to Image(s) completed."); // ExEnd:1 }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Filter worksheets using CustomLoadFilter class LoadOptions loadOpts = new LoadOptions(); loadOpts.LoadFilter = new CustomLoadFilter(); // Load the workbook with filter defined in CustomLoadFilter class Workbook workbook = new Workbook(sourceDir + "sampleCustomFilteringPerWorksheet.xlsx", loadOpts); // Take the image of all worksheets one by one for (int i = 0; i < workbook.Worksheets.Count; i++) { // Access worksheet at index i Worksheet worksheet = workbook.Worksheets[i]; // Create an instance of ImageOrPrintOptions // Render entire worksheet to image ImageOrPrintOptions imageOpts = new ImageOrPrintOptions(); imageOpts.OnePagePerSheet = true; imageOpts.ImageFormat = ImageFormat.Png; // Convert worksheet to image SheetRender render = new SheetRender(worksheet, imageOpts); render.ToImage(0, outputDir + "outputCustomFilteringPerWorksheet_" + worksheet.Name + ".png"); } Console.WriteLine("CustomFilteringPerWorksheet executed successfully."); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Create a new Workbook object //Open a template excel file Workbook book = new Workbook(dataDir+ "Testbook.xlsx"); //Get the first worksheet. Worksheet sheet = book.Worksheets[0]; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); //Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Render the image for the sheet Bitmap bitmap = sr.ToImage(0); //Save the image file bitmap.Save(dataDir+ "SheetImage.jpg"); }
public static void Main() { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Instantiate and open an Excel file Workbook book = new Workbook(dataDir+ "book1.xlsx"); //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); //Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Set the vertical and horizontal resolution imgOptions.VerticalResolution = 200; imgOptions.HorizontalResolution = 200; //One page per sheet is enabled imgOptions.OnePagePerSheet = true; //Get the first worksheet Worksheet sheet = book.Worksheets[0]; //Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Render the image for the sheet Bitmap bmp = sr.ToImage(0); //Create a bitmap Bitmap thumb = new Bitmap(100, 100); //Get the graphics for the bitmap System.Drawing.Graphics gr = System.Drawing.Graphics.FromImage(thumb); //Draw the image gr.DrawImage(bmp, 0, 0, 100, 100); //Save the thumbnail thumb.Save(dataDir+ "mythumbnail.out.bmp"); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); string filePath = dataDir + "Template.xlsx"; //Create a workbook object from the template file Workbook book = new Workbook(filePath); //Convert each worksheet into svg format in a single page. ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.SaveFormat = SaveFormat.SVG; imgOptions.OnePagePerSheet = true; //Convert each worksheet into svg format foreach (Worksheet sheet in book.Worksheets) { SheetRender sr = new SheetRender(sheet, imgOptions); for (int i = 0; i < sr.PageCount; i++) { //Output the worksheet into Svg image format sr.ToImage(i, filePath + sheet.Name + i + ".out.svg"); } } }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); //Load the sample Excel file Workbook wb = new Workbook(sourceDir + "sampleImageOrPrintOptions_PageIndexPageCount.xlsx"); //Access the first worksheet Worksheet ws = wb.Worksheets[0]; //Specify image or print options //We want to print pages 4, 5, 6, 7 ImageOrPrintOptions opts = new ImageOrPrintOptions(); opts.PageIndex = 3; opts.PageCount = 4; opts.ImageFormat = System.Drawing.Imaging.ImageFormat.Png; //Create sheet render object SheetRender sr = new SheetRender(ws, opts); //Print all the pages as images for (int i = opts.PageIndex; i < sr.PageCount; i++) { sr.ToImage(i, outputDir + "outputImage-" + (i + 1) + ".png"); } Console.WriteLine("RenderLimitedNoOfSequentialPages executed successfully.\r\n"); }
public static void Main() { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); string filePath = dataDir + "aspose-sample.xlsx"; //Create workbook from source file. Workbook workbook = new Workbook(filePath); //Access the first worksheet Worksheet worksheet = workbook.Worksheets[0]; //Set the print area with your desired range worksheet.PageSetup.PrintArea = "E12:H16"; //Set all margins as 0 worksheet.PageSetup.LeftMargin = 0; worksheet.PageSetup.RightMargin = 0; worksheet.PageSetup.TopMargin = 0; worksheet.PageSetup.BottomMargin = 0; //Set OnePagePerSheet option as true ImageOrPrintOptions options = new ImageOrPrintOptions(); options.OnePagePerSheet = true; options.ImageFormat = ImageFormat.Jpeg; //Take the image of your worksheet SheetRender sr = new SheetRender(worksheet, options); sr.ToImage(0, dataDir + "output.jpg"); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); //Create a new Workbook object and //open a template Excel file. Workbook book = new Workbook(dataDir + "MyTestBook1.xls"); //Get the first worksheet. Worksheet sheet = book.Worksheets[0]; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); //Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Only one page for the whole sheet would be rendered imgOptions.OnePagePerSheet = true; //Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Render the image for the sheet Bitmap bitmap = sr.ToImage(0); //Save the image file specifying its image format. bitmap.Save(dataDir + "SheetImage.jpg"); // Display result, so that user knows the processing has finished. System.Console.WriteLine("Conversion to Image(s) completed."); }
public static void Run() { string dataDir = RunExamples.GetDataDir_Shapes(); //ExStart:ImageAsEMF Workbook book = new Workbook(dataDir + "chart.xlsx"); Worksheet sheet = book.Worksheets[0]; Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.HorizontalResolution = 200; options.VerticalResolution = 200; options.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf; //Save the workbook to stream SheetRender sr = new SheetRender(sheet, options); Presentation pres = new Presentation(); pres.Slides.RemoveAt(0); String EmfSheetName = ""; for (int j = 0; j < sr.PageCount; j++) { EmfSheetName = dataDir + "test" + sheet.Name + " Page" + (j + 1) + ".out.emf"; sr.ToImage(j, EmfSheetName); var bytes = File.ReadAllBytes(EmfSheetName); var emfImage = pres.Images.AddImage(bytes); ISlide slide = pres.Slides.AddEmptySlide(pres.LayoutSlides.GetByType(SlideLayoutType.Blank)); var m = slide.Shapes.AddPictureFrame(ShapeType.Rectangle, 0, 0, pres.SlideSize.Size.Width, pres.SlideSize.Size.Height, emfImage); } pres.Save(dataDir + "Saved.pptx", Aspose.Slides.Export.SaveFormat.Pptx); //ExEnd:ImageAsEMF }
public static void Run() { //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Open a template excel file Workbook book = new Workbook(sourceDir + "sampleConvertWorksheettoImageFile.xlsx"); // Get the first worksheet. Worksheet sheet = book.Worksheets[0]; // Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.OnePagePerSheet = true; // Specify the image format imgOptions.ImageType = Drawing.ImageType.Jpeg; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); // Render the image for the sheet Bitmap bitmap = sr.ToImage(0); // Save the image file bitmap.Save(outputDir + "outputConvertWorksheettoImageFile.jpg"); Console.WriteLine("ConvertWorksheettoImageFile executed successfully."); }
public static void Main() { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Instantiate a workbook //Open the template file Workbook book = new Workbook(dataDir+ "MyTestBook1.xlsx"); //Get the first worksheet Worksheet sheet = book.Worksheets[0]; //Specify your print area if you want //sheet.PageSetup.PrintArea = "A1:H8"; //To remove the white border around the image. sheet.PageSetup.LeftMargin = 0; sheet.PageSetup.RightMargin = 0; sheet.PageSetup.BottomMargin = 0; sheet.PageSetup.TopMargin = 0; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf; //Set only one page would be rendered for the image imgOptions.OnePagePerSheet = true; imgOptions.PrintingPage = PrintingPageType.IgnoreBlank; //Create the SheetRender object based on the sheet with its //ImageOrPrintOptions attributes SheetRender sr = new SheetRender(sheet, imgOptions); //Convert the image sr.ToImage(0, dataDir+ "img_MyTestBook1.emf"); }
/// <summary> /// 把给定的json数据解析到对应的excle中 /// </summary> /// <param name="strContent">数据格式</param> /// {"count":12,"done":[{"que_no":"1005","win_no":"1"},{"que_no":"1004","win_no":"1"},{"que_no":"1003","win_no":"1"},{"que_no":"1002","win_no":"1"},{"que_no":"1001","win_no":"1"}],"wait":"1006,1007,1008,1009"} public void writeXLS(string strContent) { try { // string Template_File_Path = @".\wj_led.xlsx"; string Template_File_Path = @".\Template\wj_led.xlsx"; // 打开 Excel 模板 Workbook CurrentWorkbook = File.Exists(Template_File_Path) ? new Workbook(Template_File_Path) : new Workbook(); // 打开第一个sheet Worksheet DetailSheet = CurrentWorkbook.Worksheets[0]; //得到对应的json数据,定义json格式如下 //{"count":12,"done":[{"que_no":"1005","win_no":"1"},{"que_no":"1004","win_no":"1"},{"que_no":"1003","win_no":"1"},{"que_no":"1002","win_no":"1"},{"que_no":"1001","win_no":"1"}],"wait":"1006,1007,1008,1009"} JObject jobj = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(strContent); int istart = 5; foreach (JObject jo in jobj["done"]) { DetailSheet.Cells[$"B{istart}"].PutValue($"请{jo["que_no"]}号到{jo["win_no"]}号窗口办理业务"); istart++; } string[] arrWait = jobj["wait"].ToString().Split(','); //得到等待队列 for (int i = 0; i < arrWait.Length; i++) { int iIndex = i / 2 + 5; if (i % 2 == 0) //双数 F { DetailSheet.Cells[$"E{iIndex}"].PutValue(arrWait[i]); } else //单数 E { DetailSheet.Cells[$"F{iIndex}"].PutValue(arrWait[i]); } } DetailSheet.Cells["E4"].PutValue($"({jobj["count"]}位等待)"); PageSetup pageSetup = DetailSheet.PageSetup; pageSetup.Orientation = PageOrientationType.Portrait; pageSetup.LeftMargin = 0.3; pageSetup.RightMargin = 0.5; pageSetup.BottomMargin = 0.5; pageSetup.PaperSize = PaperSizeType.Custom; pageSetup.PrintArea = "A1:H13"; Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.OnlyArea = true; options.ImageFormat = System.Drawing.Imaging.ImageFormat.Png; options.PrintingPage = PrintingPageType.IgnoreStyle; options.PrintWithStatusDialog = false; SheetRender sr = new SheetRender(DetailSheet, options); sr.ToImage(0, "sstest.png"); } catch (Exception ex) { throw (ex); } }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create workbook object. Workbook wb = new Workbook(); // Set default font of the workbook to none Style s = wb.DefaultStyle; s.Font.Name = ""; wb.DefaultStyle = s; // Access first worksheet. Worksheet ws = wb.Worksheets[0]; // Access cell A4 and add some text inside it. Cell cell = ws.Cells["A4"]; cell.PutValue("This text has some unknown or invalid font which does not exist."); // Set the font of cell A4 which is unknown. Style st = cell.GetStyle(); st.Font.Name = "UnknownNotExist"; st.Font.Size = 20; st.IsTextWrapped = true; cell.SetStyle(st); // Set first column width and fourth column height ws.Cells.SetColumnWidth(0, 80); ws.Cells.SetRowHeight(3, 60); // Create image or print options. ImageOrPrintOptions opts = new ImageOrPrintOptions(); opts.OnePagePerSheet = true; opts.ImageType = Drawing.ImageType.Png; // Render worksheet image with Courier New as default font. opts.DefaultFont = "Courier New"; SheetRender sr = new SheetRender(ws, opts); sr.ToImage(0, "out_courier_new_out.png"); // Render worksheet image again with Times New Roman as default font. opts.DefaultFont = "Times New Roman"; sr = new SheetRender(ws, opts); sr.ToImage(0, "times_new_roman_out.png"); // ExEnd:1 }
public static void Run() { // ExStart:1 //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Instantiate and open an Excel file Workbook book = new Workbook(sourceDir + "sampleGenerateThumbnailOfWorksheet.xlsx"); // Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); // Specify the image format imgOptions.ImageType = Drawing.ImageType.Jpeg; // Set the vertical and horizontal resolution imgOptions.VerticalResolution = 200; imgOptions.HorizontalResolution = 200; // One page per sheet is enabled imgOptions.OnePagePerSheet = true; // Get the first worksheet Worksheet sheet = book.Worksheets[0]; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); // Render the image for the sheet Bitmap bmp = sr.ToImage(0); // Create a bitmap Bitmap thumb = new Bitmap(600, 600); // Get the graphics for the bitmap System.Drawing.Graphics gr = System.Drawing.Graphics.FromImage(thumb); if (bmp != null) { // Draw the image gr.DrawImage(bmp, 0, 0, 600, 600); } // Save the thumbnail thumb.Save(outputDir + "outputGenerateThumbnailOfWorksheet.bmp"); // ExEnd:1 Console.WriteLine("GenerateThumbnailOfWorksheet executed successfully.\r\n"); }
public static void Main() { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); //Instantiate a new Workbook //Load an Excel file Workbook wb = new Workbook(dataDir+ "Book1.xlsx"); //Instantiate SheetRender object based on the first worksheet //Set the ImageOrPrintOptions with desired pixel format (24 bits per pixel) and image format type SheetRender sr = new SheetRender(wb.Worksheets[0], new ImageOrPrintOptions { PixelFormat = PixelFormat.Format24bppRgb, ImageFormat = ImageFormat.Tiff }); //Save the image (first page of the sheet) with the specified options sr.ToImage(0, dataDir+ "outImage1.tiff"); }
public static void Main() { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Instantiate a new Workbook //Load an Excel file Workbook wb = new Workbook(dataDir+ "Book1.xlsx"); //Instantiate SheetRender object based on the first worksheet //Set the ImageOrPrintOptions with desired pixel format (24 bits per pixel) and image format type SheetRender sr = new SheetRender(wb.Worksheets[0], new ImageOrPrintOptions { PixelFormat = PixelFormat.Format24bppRgb, ImageFormat = ImageFormat.Tiff }); //Save the image (first page of the sheet) with the specified options sr.ToImage(0, dataDir+ "outImage1.out.tiff"); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create workbook object. Workbook wb = new Workbook(); // Set default font of the workbook to none Style s = wb.DefaultStyle; s.Font.Name = ""; wb.DefaultStyle = s; // Access first worksheet. Worksheet ws = wb.Worksheets[0]; // Access cell A4 and add some text inside it. Cell cell = ws.Cells["A4"]; cell.PutValue("This text has some unknown or invalid font which does not exist."); // Set the font of cell A4 which is unknown. Style st = cell.GetStyle(); st.Font.Name = "UnknownNotExist"; st.Font.Size = 20; st.IsTextWrapped = true; cell.SetStyle(st); // Set first column width and fourth column height ws.Cells.SetColumnWidth(0, 80); ws.Cells.SetRowHeight(3, 60); // Create image or print options. ImageOrPrintOptions opts = new ImageOrPrintOptions(); opts.OnePagePerSheet = true; opts.ImageFormat = ImageFormat.Png; // Render worksheet image with Courier New as default font. opts.DefaultFont = "Courier New"; SheetRender sr = new SheetRender(ws, opts); sr.ToImage(0, "out_courier_new_out.png"); // Render worksheet image again with Times New Roman as default font. opts.DefaultFont = "Times New Roman"; sr = new SheetRender(ws, opts); sr.ToImage(0, "times_new_roman_out.png"); // ExEnd:1 }
protected override Stream ExtractImage(int pageIndex) { var stream = new MemoryStream(); Worksheet sheet = _book.Worksheets[pageIndex]; sheet.PageSetup.LeftMargin = 1; sheet.PageSetup.RightMargin = 1; sheet.PageSetup.BottomMargin = 1; sheet.PageSetup.TopMargin = 1; SheetRender sr = new SheetRender(sheet, _options); sr.ToImage(0, stream); return(stream); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dataDir + "Testbook1.xlsx", new Aspose.Cells.LoadOptions(Aspose.Cells.LoadFormat.Xlsx)); foreach (Worksheet ws in wb.Worksheets) { SheetRender sr = new SheetRender(ws, new ImageOrPrintOptions() { OnePagePerSheet = true, ImageFormat = ImageFormat.Jpeg }); sr.ToImage(0, dataDir + "Img_" + ws.Index + "_out.jpg"); } // ExEnd:1 }
public static void Run() { // ExStart:1 //Source directory string sourceDir = RunExamples.Get_SourceDirectory(); //Output directory string outputDir = RunExamples.Get_OutputDirectory(); //Open template Workbook book = new Workbook(sourceDir + "sampleWorksheetToAnImage.xlsx"); // Get the first worksheet Worksheet sheet = book.Worksheets[0]; // Apply different Image and Print options Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); // Set Horizontal Resolution options.HorizontalResolution = 300; // Set Vertical Resolution options.VerticalResolution = 300; // Set TiffCompression options.TiffCompression = Aspose.Cells.Rendering.TiffCompression.CompressionLZW; // Set Autofit options options.IsCellAutoFit = false; // Set Image Format options.ImageType = Drawing.ImageType.Tiff; // Set printing page type options.PrintingPage = PrintingPageType.Default; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, options); // Render/save the image for the sheet int pageIndex = 3; sr.ToImage(pageIndex, outputDir + @"outputWorksheetToAnImage_" + (pageIndex + 1) + ".tiff"); // ExEnd:1 Console.WriteLine("WorksheetToAnImage executed successfully."); }
public static void Main() { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Instantiate a new Workbook //Load an Excel file Workbook wb = new Workbook(dataDir + "Book1.xlsx"); //Instantiate SheetRender object based on the first worksheet //Set the ImageOrPrintOptions with desired pixel format (24 bits per pixel) and image format type SheetRender sr = new SheetRender(wb.Worksheets[0], new ImageOrPrintOptions { PixelFormat = PixelFormat.Format24bppRgb, ImageFormat = ImageFormat.Tiff }); //Save the image (first page of the sheet) with the specified options sr.ToImage(0, dataDir + "outImage1.out.tiff"); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); Workbook book = new Workbook(dataDir+ "TestData.xlsx"); Worksheet sheet = book.Worksheets[0]; Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.HorizontalResolution = 200; options.VerticalResolution = 200; options.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff; //Sheet2Image By Page conversion SheetRender sr = new SheetRender(sheet, options); for (int j = 0; j < sr.PageCount; j++) { sr.ToImage(j, dataDir+ "test" + sheet.Name + " Page" + (j + 1) + ".tif"); } }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); Workbook book = new Workbook(dataDir+ "TestData.xlsx"); Worksheet sheet = book.Worksheets[0]; Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.HorizontalResolution = 200; options.VerticalResolution = 200; options.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff; //Sheet2Image By Page conversion SheetRender sr = new SheetRender(sheet, options); for (int j = 0; j < sr.PageCount; j++) { sr.ToImage(j, dataDir+ "test" + sheet.Name + " Page" + (j + 1) + ".out.tif"); } }
static void Main(string[] args) { string MyDir = @"Files\"; Workbook book = new Workbook(MyDir + "Sheet to Image by Page.xls"); Worksheet sheet = book.Worksheets[0]; Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); options.HorizontalResolution = 200; options.VerticalResolution = 200; options.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff; //Sheet2Image By Page conversion SheetRender sr = new SheetRender(sheet, options); for (int j = 0; j < sr.PageCount; j++) { Bitmap pic = sr.ToImage(j); pic.Save(MyDir + sheet.Name + " Page" + (j + 1) + ".tiff"); } }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Open template Workbook book = new Workbook(dataDir + "Testbook1.xlsx"); // Get the first worksheet Worksheet sheet = book.Worksheets[0]; // Apply different Image and Print options Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions(); // Set Horizontal Resolution options.HorizontalResolution = 300; // Set Vertical Resolution options.VerticalResolution = 300; // Set TiffCompression options.TiffCompression = Aspose.Cells.Rendering.TiffCompression.CompressionLZW; // Set Autofit options options.IsCellAutoFit = false; // Set Image Format options.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff; // Set printing page type options.PrintingPage = PrintingPageType.Default; // Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, options); // Render/save the image for the sheet sr.ToImage(0, dataDir + @"SheetImage_out.tiff"); // ExEnd:1 }
public static void Main() { // The path to the documents directory. string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); //Create workbook object from source file Workbook wb = new Workbook(dataDir+ "aspose-sample.xlsx"); //Apply different image or print options var imgOption = new ImageOrPrintOptions(); imgOption.ImageFormat = ImageFormat.Png; imgOption.HorizontalResolution = 200; imgOption.VerticalResolution = 200; imgOption.OnePagePerSheet = true; //Apply transparency to the output image imgOption.Transparent = true; //Create image after apply image or print options var sr = new SheetRender(wb.Worksheets[0], imgOption); sr.ToImage(0, dataDir+ "output.out.png"); }
static void Main(string[] args) { string MyDir = @"Files\"; //Create a new Workbook object //Open a template excel file Workbook book = new Workbook(MyDir+"Sheet to Image.xls"); //Get the first worksheet. Worksheet sheet = book.Worksheets[0]; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); //Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Render the image for the sheet Bitmap bitmap = sr.ToImage(0); //Save the image file bitmap.Save(MyDir+"SheetImage.jpg"); }
public static void Main() { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); //Create workbook object from source file Workbook wb = new Workbook(dataDir+ "aspose-sample.xlsx"); //Apply different image or print options var imgOption = new ImageOrPrintOptions(); imgOption.ImageFormat = ImageFormat.Png; imgOption.HorizontalResolution = 200; imgOption.VerticalResolution = 200; imgOption.OnePagePerSheet = true; //Apply transparency to the output image imgOption.Transparent = true; //Create image after apply image or print options var sr = new SheetRender(wb.Worksheets[0], imgOption); sr.ToImage(0, dataDir+ "output.png"); }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); //Create a new Workbook object //Open a template excel file Workbook book = new Workbook(dataDir+ "Testbook.xlsx"); //Get the first worksheet. Worksheet sheet = book.Worksheets[0]; //Define ImageOrPrintOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); //Specify the image format imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; //Render the sheet with respect to specified image/print options SheetRender sr = new SheetRender(sheet, imgOptions); //Render the image for the sheet Bitmap bitmap = sr.ToImage(0); //Save the image file bitmap.Save(dataDir+ "SheetImage.jpg"); }
public void CreateStaticReport() { //Open template string path = System.Web.HttpContext.Current.Server.MapPath("~"); path = path.Substring(0, path.LastIndexOf("\\")); string outpath = path; path += @"\designer\ProductList.xls"; outpath += @"\designer\Output\"; //Lnks will be used to get the output files for later use ArrayList lnks = new ArrayList(); //Create a workbook object from the template file Workbook book = new Workbook(path); //Convert each worksheet into svg format in a single page. ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); imgOptions.SaveFormat = SaveFormat.SVG; imgOptions.OnePagePerSheet = true; //Convert each worksheet into svg format foreach (Worksheet worksheet in book.Worksheets) { SheetRender sr = new SheetRender(worksheet, imgOptions); for (int i = 0; i < sr.PageCount; i++) { string svgFileName = "ProductList" + worksheet.Index + i + ".svg"; lnks.Add(svgFileName); //Output the worksheet into Svg format sr.ToImage(i, outpath + svgFileName); } } //Show links to all output svg files Literal ltr=new Literal(); ltr.Text="<ul>"; outPanel.Controls.Add(ltr); foreach (string lnk in lnks) { ltr = new Literal(); ltr.Text = "<li>"; outPanel.Controls.Add(ltr); HyperLink hyp = new HyperLink(); hyp.ID = lnk; hyp.Text = lnk; ; hyp.NavigateUrl = "~/designer/Output/" + lnk; outPanel.Controls.Add(hyp); ltr = new Literal(); ltr.Text = "</li>"; outPanel.Controls.Add(ltr); } ltr = new Literal(); ltr.Text = "</ul>"; outPanel.Controls.Add(ltr); }
/// <summary> /// Excel转为图片 /// </summary> /// <param name="source">源文件路径</param> /// <param name="target">图片保存的文件夹路径</param> /// <param name="dpi">dpi</param> /// <param name="format">图片格式</param> public static bool ConverToImage(string source, string target, int resolution = 300, AsposeConvertDelegate d = null) { double percent = 0.0; int page = 0; int total = 0; double second = 0; string path = ""; string message = ""; DateTime startTime = DateTime.Now; if (!FileUtil.CreateDirectory(target)) { throw new DirectoryNotFoundException(); } if (!File.Exists(source)) { throw new FileNotFoundException(); } if (d != null) { second = (DateTime.Now - startTime).TotalSeconds; percent = 0.1; message = "正在解析文件!"; d.Invoke(percent, page, total, second, path, message); } LoadOptions loadOptions = new LoadOptions(LoadFormat.Auto); Workbook workbook = new Workbook(source, loadOptions); total = workbook.Worksheets.Count; if (d != null) { second = (DateTime.Now - startTime).TotalSeconds; percent = 0.2; message = "开始转换文件,共" + total + "页!"; d.Invoke(percent, page, total, second, path, message); } logger.Info("ConverToImage - source=" + source + ", target=" + target + ", pageCount=" + total); for (page = 0; page < total; page++) { Worksheet sheet = workbook.Worksheets[page]; ImageOrPrintOptions op = new ImageOrPrintOptions(); op.ImageFormat = ImageFormat.Png; op.HorizontalResolution = resolution; op.VerticalResolution = resolution; SheetRender sr = new SheetRender(sheet, op); for (int j = 0; j < sr.PageCount; j++ ) { Bitmap bitmap = sr.ToImage(j); path = target + "\\" + (page + 1) + "_" + (j + 1) + ".png"; bitmap.Save(path); if (d != null) { second = (DateTime.Now - startTime).TotalSeconds; percent = 0.2 + (page + 1) * 0.8 / total; message = "正在转换第" + (page + 1) + "/" + total + "页!"; d.Invoke(percent, (page + 1), total, second, path, message); } } } return true; }