Exporting xlsx spreasheet into a tab-separated flat file?
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
tatamata · 2020-02-16 19:23

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?
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i 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;

----------------------------------------------------------------------
winni · 2020-02-16 20:13

Hi!

The record TsCSVParams has a member  called Delimeter.
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i var Para :
TsCSVParams;beginPara.Delimeter := #9; // TAB....
This page has a good explanation  about fpSpeadSheet

https://wiki.freepascal.org/FPSpreadsheet

Winni