读写XLSM文件格式

可能的使用场景

Microsoft Excel支持许多格式,如XLS、XLSX、XLSM、XLSB、CSV等。Aspose.Cells也支持其中许多格式。本文介绍了如何使用Aspose.Cells读取和写入具有XLSM格式的Excel文件。

读写XLSM文件格式

以下示例代码加载了源XLSM文件,读取其单元格A1,然后将其内容复制到单元格C4,并将其另存为输出XLSM文件

示例代码

Aspose::Cells::Startup();
//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C
//Source directory path
U16String dirPath(u"..\\Data\\LoadingSavingAndConverting\\");
//Output directory path
U16String outPath(u"..\\Data\\Output\\");
//Path of input excel file
U16String srcReadWriteXLSM = dirPath + u"srcReadWriteXLSM.xlsm";
//Path of output excel file
U16String outReadWriteXLSM = outPath + u"outReadWriteXLSM.xlsm";
//Read source xlsm file
Workbook wb(srcReadWriteXLSM);
//Access first worksheet
Worksheet ws = wb.GetWorksheets().Get(0);
//Access cell A1
Cell cell = ws.GetCells().Get(u"A1");
//Get the string value of cell A1
U16String strVal = cell.GetStringValue();
//Print the string value of cell A1
U16String cellValue(u"Cell Value: ");
std::cout<<cellValue.ToUtf8() << strVal.ToUtf8() << std::endl;
//Access cell C4
cell = ws.GetCells().Get(u"C4");
//Put the string value of cell A1 into C4
U16String strValPtr(strVal);
cell.PutValue(strValPtr);
//Save the workbook in XLSM format
wb.Save(outReadWriteXLSM, SaveFormat::Xlsm);
Aspose::Cells::Cleanup();