topic Send to Excel Limitation in QlikView https://community.qlik.com/t5/QlikView/Send-to-Excel-Limitation/m-p/172066#M41763 <HTML><HEAD></HEAD><BODY><P>I have a Table box were one of the column contains large text. When I use Send to Excel button on caption the cell that contains text in the result excel file is truncated to 255 char. Does any one knows how to overcome this problem?</P></BODY></HTML> Mon, 21 Mar 2011 15:36:31 GMT 2011-03-21T15:36:31Z Send to Excel Limitation https://community.qlik.com/t5/QlikView/Send-to-Excel-Limitation/m-p/172066#M41763 <HTML><HEAD></HEAD><BODY><P>I have a Table box were one of the column contains large text. When I use Send to Excel button on caption the cell that contains text in the result excel file is truncated to 255 char. Does any one knows how to overcome this problem?</P></BODY></HTML> Mon, 21 Mar 2011 15:36:31 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Limitation/m-p/172066#M41763 2011-03-21T15:36:31Z Send to Excel Limitation https://community.qlik.com/t5/QlikView/Send-to-Excel-Limitation/m-p/172067#M41764 <HTML><HEAD></HEAD><BODY><P>You can do it using a macro like this:<BR /></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />sub Export<BR /> ActiveDocument.GetSheetObject("TX01").CopyTextToClipboard<BR /> set XLApp = CreateObject("Excel.Application")<BR /> XLApp.Visible = True<BR /> set XLDoc = XLApp.Workbooks.Add<BR /> set XLSheet = XLDoc.Worksheets(1)<BR /> XLSheet.Paste XLSheet.Range("A1")<BR />end sub<BR /></PRE></BLOCKQUOTE><BR />(it requires system access)<BR /><BR /></BODY></HTML> Mon, 21 Mar 2011 17:17:14 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Limitation/m-p/172067#M41764 Anonymous 2011-03-21T17:17:14Z