With the CSV adapter you can export a csv file with a specific content.
Syntax
public class CSVDocument
Members
CSVDocument(string Delimiter = ";", string stringEscape="\"", string Escape="\\", string LineBreak = "\r\n") |
The constructor |
|
void SetValue(int row, int col, object value) |
Sets a value into a specified row and column |
|
void SaveAs(Stream s) |
Saves the file |
Sample
This sample creates a .csv file with given values
import clr
clr.AddReferenceToFileAndPath(Session.GetAdapterPath("CSV"))
from IYOPROCsvAdapter import CSVDocument
import System
from System.IO import FileStream, FileMode
fs = FileStream("CSVSample.csv", FileMode.Create)
csv = CSVDocument()
#Header
csv.SetValue(1, 1, "Column A")
csv.SetValue(1, 2, "Column B")
csv.SetValue(1, 3, "Column C")
#Content
csv.SetValue(2, 1, "Hello")
csv.SetValue(2, 2, 3)
csv.SetValue(2, 3, 4.2)
csv.SaveAs(fs)
fs.Close()
This sample creates and saves a .csv file with values of a data grid
import clr
clr.AddReferenceToFileAndPath(Session.GetAdapterPath("CSV"))
from IYOPROCsvAdapter import CSVDocument
import System
from System.IO import FileStream, FileMode
#Specify storage location and file name
localFile = "D:\\CSV Example Folder\\CSVSample.csv"
fs = FileStream(localFile, FileMode.Create)
csv = CSVDocument()
#Header (first row)
csv.SetValue(1, 1, "Column A")
csv.SetValue(1, 2, "Column B")
csv.SetValue(1, 3, "Column C")
#Content (from second row onwards)
i = 2
for entry in grid:
csv.SetValue(i, 1, entry["<key>"])
csv.SetValue(i, 2, entry["<key>"])
csv.SetValue(i, 3, entry["<key>"])
i = i + 1
csv.SaveAs(fs)
fs.Close()