Hi, trying to export a spreadsheet to a tab-delimited file (CSV file with "\t" as field separator).
How to specify specific field separator ("\t") for the TsWorkbook.WriteToFile (vDestFileName, sfCSV, True) ?
Any other convenient way to export xlsx spreadsheet into a tab-separated file?
function ExportSpreadsheetToTabFile(pFileName:string): string;
var
MyWorkbook: TsWorkbook;
vSourceFileName: string;
vDestFileName: string;
begin
vSourceFileName:=pFileName;
vDestFileName:= ExtractFileNameWithoutExt(pFileName) + '.tab';
try
MyWorkbook := TsWorkbook.Create;
MyWorkbook.ReadFromFile(vSourceFileName);
MyWorkbook.WriteToFile(vDestFileName, sfCSV, True); //How to specify field delimiter?!?
ExportSpreadsheetToTabFile:=vDestFileName;
finally
MyWorkbook.Free;
end;
end;