Load or Import CSV file with Formulas
Contents
[
Hide
]
CSV file mostly contains textual data and they do not contain any formulas. However, sometimes it happens that CSV files also contain formulas. Such CSV files should be loaded by setting the TxtLoadOptions.has_formula as true. Once this property will be set true, Aspose.Cells will not treat formula as simple text. They will be treated as formula and Aspose.Cells formula calculation engine will process them as usual.
The following code illustrates how you can load as well as import a CSV file with formulas. You can use any CSV file. For illustration purpose, we use the simple csv file which contains this data. As you see it contains a formula.
300,500,=Sum(A1:B1)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import TxtLoadOptions, Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| opts = TxtLoadOptions() | |
| opts.separator = ',' | |
| opts.has_formula = True | |
| # Load your CSV file with formulas in a Workbook object | |
| workbook = Workbook(dataDir + "sample.csv", opts) | |
| # You can also import your CSV file like this | |
| # The code below is importing CSV file starting from cell D4 | |
| worksheet = workbook.worksheets[0] | |
| worksheet.cells.import_csv(dataDir + "sample.csv", opts, 3, 3) | |
| # Save your workbook in Xlsx format | |
| workbook.save(dataDir + "output_out.xlsx") |
The code first loads the CSV file, then import it again at cell D4. Finally, it saves the workbook object in XSLX format. The output XLSX file looks like this. As you see cell C3 and F4 contain formula and its result 800.
 |
|---|