public static void Main(string[] args)
{
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
//Open an Excel file
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(dataDir + "Book1.xls");
//Get the first worksheet
Aspose.Cells.Worksheet sheet = workbook.Worksheets[0];
//Apply different Image and Print options
Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
//Set the Format
options.SaveFormat = SaveFormat.XPS;
//Render the sheet with respect to specified printing options
Aspose.Cells.Rendering.SheetRender sr = new Aspose.Cells.Rendering.SheetRender(sheet, options);
// Save
sr.ToImage(0, dataDir + "out_printingxps.xps");
//Export the whole workbook to XPS
Aspose.Cells.Rendering.WorkbookRender wr = new Aspose.Cells.Rendering.WorkbookRender(workbook, options);
wr.ToImage(dataDir + "out_whole_printingxps.xps");
}
public static void Main(string[] args)
{
// The path to the documents directory.
string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
//Open an Excel file
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(dataDir + "Book1.xls");
//Get the first worksheet
Aspose.Cells.Worksheet sheet = workbook.Worksheets[0];
//Apply different Image and Print options
Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
//Set the Format
options.SaveFormat = SaveFormat.XPS;
//Render the sheet with respect to specified printing options
Aspose.Cells.Rendering.SheetRender sr = new Aspose.Cells.Rendering.SheetRender(sheet, options);
// Save
sr.ToImage(0, dataDir + "out_printingxps.xps");
//Export the whole workbook to XPS
Aspose.Cells.Rendering.WorkbookRender wr = new Aspose.Cells.Rendering.WorkbookRender(workbook, options);
wr.ToImage(dataDir + "out_whole_printingxps.xps");
}
public static void Run()
{
// ExStart:1
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Open an Excel file
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(dataDir + "Book1.xls");
// Get the first worksheet
Aspose.Cells.Worksheet sheet = workbook.Worksheets[0];
// Apply different Image and Print options
Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
// Set the Format
options.SaveFormat = SaveFormat.XPS;
// Render the sheet with respect to specified printing options
Aspose.Cells.Rendering.SheetRender sr = new Aspose.Cells.Rendering.SheetRender(sheet, options);
// Save
sr.ToImage(0, dataDir + "out_printingxps.out.xps");
// Export the whole workbook to XPS
Aspose.Cells.Rendering.WorkbookRender wr = new Aspose.Cells.Rendering.WorkbookRender(workbook, options);
wr.ToImage(dataDir + "out_whole_printingxps.out.xps");
// ExEnd:1
}
private List <string> GetDocumentPages(string file, string folderName, int currentPage)
{
List <string> lstOutput = new List <string>();
string outfileName = "page_{0}";
string outPath = Config.Configuration.OutputDirectory + folderName + "/" + outfileName;
currentPage = currentPage - 1;
Directory.CreateDirectory(Config.Configuration.OutputDirectory + folderName);
string imagePath = string.Format(outPath, currentPage) + ".jpeg";
if (System.IO.File.Exists(imagePath) && currentPage > 0)
{
lstOutput.Add(imagePath);
return(lstOutput);
}
int i = currentPage;
var filename = System.IO.File.Exists(Config.Configuration.WorkingDirectory + folderName + "/" + file)
? Config.Configuration.WorkingDirectory + folderName + "/" + file
: Config.Configuration.OutputDirectory + folderName + "/" + file;
using (FilePathLock.Use(filename))
{
try
{
Aspose.Cells.Live.Demos.UI.Models.License.SetAsposeCellsLicense();
// Load the document from disk.
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(filename, new Aspose.Cells.LoadOptions());
Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
options.ImageType = Aspose.Cells.Drawing.ImageType.Jpeg;
Aspose.Cells.Rendering.WorkbookPrintingPreview workbookPrintingPreview =
new Aspose.Cells.Rendering.WorkbookPrintingPreview(workbook, options);
int pagesCounts = workbookPrintingPreview.EvaluatedPageCount;
lstOutput.Add(pagesCounts.ToString());
Aspose.Cells.Rendering.WorkbookRender renderer = new Aspose.Cells.Rendering.WorkbookRender(workbook, options);
if (renderer.PageCount > 0)
{
renderer.ToImage(currentPage, imagePath);
lstOutput.Add(imagePath);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstOutput);
}
}
