Leggere e scrivere CSV Formato file
Contents
[
Hide
]
Possibili scenari di utilizzo
Microsoft Excel supporta molti formati come XLS, XLSX, XLSM, XLSB, CSV, ecc. Aspose.Cells supporta anche molti di questi formati. Questo articolo spiega come leggere e scrivere il file excel con formato CSV usando Aspose.Cells.
Leggere e scrivere CSV Formato file
Il codice di esempio seguente carica il filefonte CSV file e legge la sua cella A1 e quindi copia il suo contenuto nella cella C4 e lo salva comeoutput CSV file.
Codice d’esempio
This file contains 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
//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C | |
//Source directory path | |
StringPtr dirPath = new String("..\\Data\\LoadingSavingAndConverting\\"); | |
//Output directory path | |
StringPtr outPath = new String("..\\Data\\Output\\"); | |
//Path of input csv file | |
StringPtr srcReadWriteCSV = dirPath->StringAppend(new String(L"srcReadWriteCSV.csv")); | |
//Path of output csv file | |
StringPtr outReadWriteCSV = outPath->StringAppend(new String(L"outReadWriteCSV.csv")); | |
//Read source csv file | |
intrusive_ptr<IWorkbook> wb = Factory::CreateIWorkbook(srcReadWriteCSV); | |
//Access first worksheet | |
intrusive_ptr<IWorksheet> ws = wb->GetIWorksheets()->GetObjectByIndex(0); | |
//Access cell A1 | |
intrusive_ptr<ICell> cell = ws->GetICells()->GetObjectByIndex(new String("A1")); | |
//Get the string value of cell A1 | |
StringPtr strVal = cell->GetStringValue(); | |
//Print the string value of cell A1 | |
StringPtr cellValue = new String("Cell Value: "); | |
Console::WriteLine(cellValue->StringAppend(strVal)); | |
//Access cell C4 | |
cell = ws->GetICells()->GetObjectByIndex(new String("C4")); | |
//Put the string value of cell A1 into C4 | |
intrusive_ptr<String> strValPtr = new String(strVal); | |
cell->PutValue(strValPtr); | |
//Save the workbook in csv format | |
wb->Save(outReadWriteCSV, SaveFormat_CSV); |