Straight Table Export help???

[amit_saini]

Ho Folks,

I'm having a straight table which contains lots of text data, when I'm exporting it to excel, the data which I'm getting looks like this "################################' . I know if I double click my sheet column I can see the complete data. Please see the attachment.

I want export data to be seen perfect not like this '###########'.  Please help me how to achieve this through straight table export??????

Thanks,

AS

[jsingh71]

amit, increase the size of row in excel after that definately you will get the values.

[amit_saini]

Hi Jsingh,

Brother I can't do this as further i need the link these column values into some other template. I want this to be work in automated fashion .

Thanks,

AS

[ashwanin]

I know its really hit and trial.

Adjust the Chart i.e increase the size of columns in Chart and then take output.

[#5]

Hi Amit,

The button is not working for me and when I click on export to excel icon, this is what I can see in excel without double clicking on any of the columns:

Looks like some excel settings need to be done in your machine.

[amit_saini]

Hi Shyamal,

Please change link here in macro code you need to give a link where you want this export to be present in your machine and second create a varible by name of vFile with value as =Test and then check this button you will be having result export shhet bythe name of Test.xls

obj.ExportEx "Give You own path here \"& vFile &".xls",5

Thanks,

AS

[#7]

If you write a macro to export you can adjust the width of the columns.

Set objXLWs = objExcelWorkbook.Sheets("Resume")

objXLWS.Columns(1).ColumnWidth = 25

[#8]

Hi Amit,

I exported using the macro and yet I am getting the above output only.

You can set the excel column width in macro, something like:

set XLSheet = XLDoc.Worksheets(1) 'your Excel sheet number with XLSheet

XLSheet.Range("A1:A60000").ColumnWidth = 10

and you can use the above line multiple times to set the width for different range of columns.

Hope this helps!

[#9]

Found this on the community, might be of help to you:

Export to Excel in formated way