public static void Main() { //Create workbook object. Workbook wb = new Workbook(); //Access built-in document property collection. Aspose.Cells.Properties.BuiltInDocumentPropertyCollection bdpc = wb.BuiltInDocumentProperties; //Set the language of the Excel file. bdpc.Language = "German, French"; //Save the workbook in xlsx format. wb.Save(outputDir + "outputSpecifyLanguageOfExcelFileUsingBuiltInDocumentProperties.xlsx", SaveFormat.Xlsx); Console.WriteLine("SpecifyLanguageOfExcelFileUsingBuiltInDocumentProperties executed successfully."); }
public static void Run() { //Create workbook object Workbook wb = new Workbook(); //Access built-in document property collection Aspose.Cells.Properties.BuiltInDocumentPropertyCollection bdpc = wb.BuiltInDocumentProperties; //Set the title bdpc.Title = "Aspose File Format APIs"; //Set the author bdpc.Author = "Aspose APIs Developers"; //Set the document version bdpc.DocumentVersion = "Aspose.Cells Version - 18.3"; //Save the workbook in xlsx format wb.Save(outputDir + "outputSpecifyDocumentVersionOfExcelFile.xlsx", SaveFormat.Xlsx); Console.WriteLine("SpecifyDocumentVersionOfExcelFile executed successfully."); }
private void ParseXls(ref FileObject fo, string filePath) { Workbook wb = new Workbook(filePath); Aspose.Cells.Properties.BuiltInDocumentPropertyCollection dp = wb.BuiltInDocumentProperties; WorksheetCollection wsc = wb.Worksheets; fo.pageCount = wsc.Count; int NoOfImages = 0; int NoOfEmbeddedDocs = 0; bool isProtected = false; foreach (Worksheet ws in wsc) { OleObjectCollection oles = ws.OleObjects; if (ws.IsProtected) { isProtected = true; } foreach (OleObject ole in oles) { switch (ole.FileFormatType) { case FileFormatType.Doc: case FileFormatType.Xlsm: case FileFormatType.Docx: case FileFormatType.Xlsx: case FileFormatType.Ppt: case FileFormatType.Pdf: case FileFormatType.CSV: case FileFormatType.VSD: case FileFormatType.VSDX: case FileFormatType.Html: case FileFormatType.XML: NoOfEmbeddedDocs++; break; case FileFormatType.BMP: case FileFormatType.TIFF: NoOfImages++; break; default: NoOfImages++; break; } } } fo.embeddedDocsCount = NoOfEmbeddedDocs; fo.imageCount = NoOfImages; fo.hasPassword = isProtected; string tmpFolderToExtract = tmpFolder + "\\" + Guid.NewGuid(); Directory.CreateDirectory(tmpFolderToExtract); string tmpTextFile = tmpFolderToExtract + "\\" + "tmpTextexport.txt"; byte[] workbookData = new byte[0]; TxtSaveOptions opts = new TxtSaveOptions(); opts.Separator = ' '; for (int idx = 0; idx < wb.Worksheets.Count; idx++) { MemoryStream ms = new MemoryStream(); wb.Worksheets.ActiveSheetIndex = idx; wb.Save(ms, opts); ms.Position = 0; byte[] sheetData = ms.ToArray(); byte[] combinedArray = new byte[workbookData.Length + sheetData.Length]; Array.Copy(workbookData, 0, combinedArray, 0, workbookData.Length); Array.Copy(sheetData, 0, combinedArray, workbookData.Length, sheetData.Length); workbookData = combinedArray; } File.WriteAllBytes(tmpTextFile, workbookData); fo.wordCount = GetWordCount(tmpTextFile); fo.characterCount = GetCharCount(tmpTextFile); if (File.Exists(tmpTextFile)) { File.Delete(tmpTextFile); } if (Directory.Exists(tmpFolderToExtract)) { Directory.Delete(tmpFolderToExtract); } }