4 Replies Latest reply: Dec 21, 2010 4:02 AM by Eran Dayan RSS

    Sending to Excel and keeping the format

    Stephen Charles

      I can send a pivot table to excel but it does not keep the formating (ie totals bold, number that are red or green etc). I can send the table to excel using the SendToExcel API and the formating is what I want, but it opens excel and the file goes to a temp directory with a name that has a time stamp.

      How can I capture this name or send it to excel with the SendToExcel API and name the file myself?

      Thanks,

      Stephen