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);
}
}
