5 Replies Latest reply on Feb 6, 2014 12:54 PM by Prem Reddy

Is there anyway to export reports from tableau server to excel using tabcmd

Haritha Maddi Feb 25, 2013 4:40 AM

Hi,

I am trying to automate the process of generating reports in excel and mail them to our client.

As we have some data which may have ',' in them, we cannot go for CSV format.

We either cannot go for PDF as the field width cannot be increased due to the horizontal scroll bar limitation in tableau.

So is there any possible way to export into excel using tabcmd.

Thanks,

Haritha

1. Re: Is there anyway to export reports from tableau server to excel using tabcmd

Cristian Vasile Feb 25, 2013 7:02 AM (in response to Haritha Maddi)

Haritha,

Could you please let me know if client has asked for excel or it is your choice to solve the issue?

You can export the viz as .png (raster image) having defined resolution and then convert it to .pdf (with extra small application) and send the report by email to client.

Example
tabcmd get "/views/....../Dashboard1.png?:size=1616,1216" -f "c:\images\report_v1.png"
or create bigger "viz"
tabcmd get "/views/....../Dashboard1.png?:size=2016,1816" -f "c:\images\report_v1.png"

Let me know if the proposed method solve your issue.

Regards,
Cristian.
Like Show 0 Likes(0)

Actions
2. Re: Is there anyway to export reports from tableau server to excel using tabcmd

Haritha Maddi Feb 25, 2013 8:19 AM (in response to Cristian Vasile)

Hi Cristian,

We store the log information related to all the jobs in a table which our client requested to mail him as a report everyday.

As few fields have values>500 characters, when we directly load into the excel it is truncating characters>255.

So client suggested us to use tableau and generate the pdf report. We have 16 rows in the report.

Rest of the problems are as explained in the above post.

So, is it possible to have the full value displayed if we follow the above procedure?

Thanks,
Haritha
Like Show 0 Likes(0)

Actions
3. Re: Is there anyway to export reports from tableau server to excel using tabcmd

Cristian Vasile Feb 25, 2013 10:09 AM (in response to Haritha Maddi)

Haritha,

If the customer is happy with .pdf format i'll suggest to design logs report from scratch and check if Tableau is able to process strings longer than 255 characters. Is no need in your case to go through a complicated process as the one proposed initial by me.

Regards,
Cristian.
Like Show 0 Likes(0)

Actions
4. Re: Is there anyway to export reports from tableau server to excel using tabcmd

Haritha Maddi Feb 25, 2013 8:42 PM (in response to Cristian Vasile)

Hi Cristian,

Thanks for your reply.

The problem with the pdf is we are unable to see the entire value in the dimension.

The data does not have any spaces in between so we cannot even wrap text. We cannot increase the width of the cell as it does not fit in a single page.

Thanks,
Haritha
Like Show 0 Likes(0)

Actions
5. Re: Is there anyway to export reports from tableau server to excel using tabcmd

Prem Reddy Feb 6, 2014 12:54 PM (in response to Haritha Maddi)

Hi,

I'm also having the same requirement as Haritha, but I want to export the session Activity report to the users. Is there any tabcmd that directly exports into excel???

Thanks,
Prem
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Is there anyway to export reports from tableau server to excel using tabcmd

1. Re: Is there anyway to export reports from tableau server to excel using tabcmd

2. Re: Is there anyway to export reports from tableau server to excel using tabcmd

3. Re: Is there anyway to export reports from tableau server to excel using tabcmd

4. Re: Is there anyway to export reports from tableau server to excel using tabcmd

5. Re: Is there anyway to export reports from tableau server to excel using tabcmd

Actions

More Like This