如何在不安装MS excel的情况下将表数据导出到excel并作为附件发送 [英] How to export the table data into excel without installing MS excel and to send as an attchment

问题描述

大家好，



我正在创建一个SSIS包的任务，该包执行一些逻辑以从用户业务操作和需要的不同表中提取数据创建一个Excel并导出数据。一旦创建了excel并将其保存在需要作为附件发送的特定文件夹中。



因为我们没有在服务器中安装excel并且保存.csv是不正常。任何人都可以建议如何实现此功能。另外，任何人都可以确认我们可以在没有安装MS excel的情况下从SSIS创建excel吗？



感谢提前



问候

Prashant P

Hi All,

I am having a task to create an SSIS package which performs some logic to extract the data from different tables for the user business operation and need to create an excel and export the data . Once the excel is created and saved in a perticular folder that need to be sent as an attchment.

As we dont have excel installed in the server and saving .csv is not working properly. Can any one suggest how to achieve this functionality. Also, Can any one comfirm whather we can create an excel from SSIS without installing MS excel ?

Thanks on advance

Regards
Prashant P

推荐答案

执行此操作的合理方法是创建CSV。这样，Excel可以打开它，并且您不需要安装任何版本的Excel，因为您只是创建一个文本文件。你说它工作不正常，但是，它非常简单，因此，不要为了另一个随机解决方案而投入，修复你拥有的代码。解释工作不正常的含义，以便我们帮助您解决问题。

The logical way to do this is to create a CSV. That way, Excel can open it, and you don't need any version of Excel installed, because you're just creating a text file. You say that's 'not working properly', but, it's really simple, so, don't cast about for another random solution, fix the code you have. Explain what 'not working properly' means, so we can help you fix it.

这篇关于如何在不安装MS excel的情况下将表数据导出到excel并作为附件发送的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！