Hi Syed,
You don't need anything special to export Excel files, you just need the
same web server and templating modules that you use to serve HTML.
Set a Content-Disposition header in your response, and output an HTML3
document containing just a table, then Excel will be a happy bunny.
e.g.
Content-Disposition: attachment; filename="my-spreadsheet.xls"
<html>
<body>
<table>
<tr>
<td>A spreadsheet with one cell</td>
</tr>
</table>
</body>
</html>
On 27 November 2013 22:26, Michael J. Ryan <[email protected]> wrote:
> If you use MS-SQL server, would suggest the “tedious” module over the
> MS one... it’s more portable. You may want to consider PostgreSQL or MySQL
> if either are an option (I prefer PostreSQL). (based on what your are
> describing for your data, I would lean towards an SQL database vs a
> non-relational db... Some use cases are better suited for NoSQL, yours
> doesn’t seem to be one of them)
>
> You can mount endpoints pretty easily with nodejs, though there are some
> REST frameworks for getting you going faster.
>
> For running the application as a service in windows, you’ll likely want to
> use NSSM (Non-Sucking Service Manager) to create your service entry in
> windows. For Linux, depends on your distro & version.
>
> As for “exporting” to excel if you only need one worksheet would just
> output to CSV which excel can open (then re-save) fine... if you need more,
> there are libraries, but they come with a little more overhead.
>
>
> *From:* Syed Haani <[email protected]>
> *Sent:* Wednesday, November 27, 2013 4:55 AM
> *To:* [email protected]
> *Subject:* [nodejs] Node.js support for Exporting excel and Database
>
>
> I am new to node.js.
>
> I am currently in a pre-development phase of an application.
>
> The application will be for tracking status of task of employee. The admin
> will have the right to export excel which will have data of employes for a
> given date range
>
> Currently I am thinking WCF Service and SQL Server for the backend.
>
> Few days back, someone told me about node.js and it's capabilities. And
> yes I was impressed
>
> I wanted to know if I write a service with node.js, how will the service
> be hosted, also if I can write code for exporting data in excel, and lastly
> which database providers/adapters does node.js support?
>
> Apologies if there is typo or this question need to be asked in any other
> community of stackExchange.
>
> Thanks in advance
>
> Syed
> --
> --
> Job Board: http://jobs.nodejs.org/
> Posting guidelines:
> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> You received this message because you are subscribed to the Google
> Groups "nodejs" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/nodejs?hl=en?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "nodejs" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> --
> Job Board: http://jobs.nodejs.org/
> Posting guidelines:
> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> You received this message because you are subscribed to the Google
> Groups "nodejs" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/nodejs?hl=en?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "nodejs" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Richard Marr
--
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
