topic Truncating data when Exporting to Excel in QlikView

Truncating data when Exporting to Excel

Wed, 30 Sep 2009 18:17:54 GMT

Although most exports to excel are numerical in nature, I have an end user that is tapping into a text based field that may have up to 900 characters. Currently when exporting to Excel 2003 SP3 the data is getting truncated at 255 characters.

Is there anything I can do to get the full text of the field and is this behavior consistent with newer versions of Excel?

Truncating data when Exporting to Excel

Wed, 30 Sep 2009 20:22:37 GMT

Hi,

the only possilbility I know is to write a custom export with a macro like the following and like demonstrated in the attached file.

This would not truncate long strings (in comparison to the bultin-function of QlikView for exporting to Excel); but I have to note, that I am using Excel 2007, so just do some tests with the attached file.

Best regards

Stefan



sub exportToExcel
set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True

set XLDoc = XLApp.Workbooks.Add
set table = ActiveDocument.GetSheetObject("LB01")

'Copy table and paste into Excel
set XLSheet = XLDoc.Worksheets(1) 'get the reference to the first sheet
table.CopyTableToClipboard true
XLSheet.Paste XLSheet.Range("A1") 'column where to paste the content

end sub

Truncating data when Exporting to Excel

Tue, 21 Sep 2010 00:39:52 GMT

I've verified this answer and it works great! Thanks Stefan.

Truncating data when Exporting to Excel

Thu, 25 Nov 2010 13:05:20 GMT

I was dealing with the same issue but really didnt want to use a macro, an alternative solution is to export your table to HTML and then import in Excel using External data import.