Message Boards Message Boards

0
|
10337 Views
|
2 Replies
|
0 Total Likes
View groups...
Share
Share this post:

Exporting XLSX files with WebMathematica

Rodrigo Murta, Looqbox
Posted 12 years ago
I know that WebMathmatica has examples do export to PDF (in link form and as direct download).
We can see it in content and contect store examples.
Here is the code for PDF:
<msp:evaluate>
          nb = MakeNotebook[];
          pdf = UseFrontEnd[ ExportString[ nb, "PDF"]];
          MSPURLStore[ pdf, "application/pdf", "notebook.pdf"]
</msp:evaluate>

I would like to know how can I do the same for Excel XLSX files;

For example, if I have this list:
list = RandomInteger[100, {20, 5}]
How can I export list as an Excel file using WebMathematica?

tks in advance
POSTED BY: Rodrigo Murta
2 Replies
Sort By:
Does ExportString not work for you with XLSX?
ExportString[{1, 2, 3, 4}, "XLSX"]

I don't have a configured and set up instance of webMathematica, but that would seem to be what you want to do by analogy.
POSTED BY: Sean Clarke
Sean, you are right! The code... works just fine.
<msp:evaluate>
           list = RandomReal[100,{100,2}];
           xlsx = UseFrontEnd[ ExportString[ list, "xlsx"]];
          MSPURLStore[ xlsx, "application/xlsx", "test_file.xlsx"]
</msp:evaluate>
tks
POSTED BY: Rodrigo Murta
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract