Export in CSV with colons or semicolons

Wed, 21 Aug 2013 13:20:58 GMT

Hi everyone !

We are working with both French users and English users, and we are looking for a solution to let the client choose the separators (colon or semicolon) when exporting datas into a csv file.

As we are working with the AJAX, is there any solution without using macros?

thanks

Re: Export in CSV with colons or semicolons

gonzaloruizgonz — Wed, 03 Sep 2014 07:13:27 GMT

Hi, This maybe work:

Sub ServerExportExcolon

Set st = ActiveDocument.GetSheetObject("LB01")

st.ServerSideExportEx "C:\test.csv", ":" ,1,850

End Sub

Sub ServerExportExsemicolon

Set st = ActiveDocument.GetSheetObject("LB01")

st.ServerSideExportEx "C:\test.csv", ";" ,1,850

End Sub

Try to connect them to a button by cal the macro in action.

BR//GOnza

topic Export in CSV with colons or semicolons in QlikView

Export in CSV with colons or semicolons

Re: Export in CSV with colons or semicolons