Excel Automation

We would like a script to run from an SSIS package that would open an Excel spreadsheet with a PowePivot datasource, refresh that datasource, save the resulting spreadsheet under the same name and print one or all tabs in the spreadsheet to a PDF file that we specify.

We would prefer the script be written in C# and be a compiled executable which we could pass ANY excel spreadsheet with a PowerPivot datasource.

The example provided in the attachments uses the AdventureWorks database that comes with SQL 2008. Please produce a solution that demonstrates how this can be refreshed without user intervention or pop-ups requiring user input.

We would like the exe to take the following parameters:

input file - the name of the Excel file we are processing

output sheet - the name of the worksheet tab we would like to export to PDF. If not specified, we would like ALL tabs to be output to the same PDF.

ouput pdf name - the name of the ouput PDF file we would like produced as a result of printing one or all tabs.

Kindly provide me the Working [url removed, login to view] guys Who have Working Demo .they can bid only.

Kemahiran: .NET, Pengaturcaraan C#, SQL

Lihat lagi: powerpivot automation, excel automation sql, powepivot, ssis script excel automation, sql pdf file, print all attachments, excel automation powerpivot, ssis excel automation, excel uses, SSIS SQL, Sql ssis, script automation, save to excel, export from excel, excel to sql, excel to pdf, c automation, automation c, sql user export, open input file, excel export pdf, sql tabs, refresh excel spreadsheet, excel can open file, net spreadsheet

Tentang Majikan:
( 0 ulasan ) Chandigarh, India

ID Projek: #1560896

4 pekerja bebas membida secara purata $475 untuk pekerjaan ini


Hi, I am interested to work on this project. I have a great experience on asp.net 4, C# .net 4,Windows service, web service, COM, CSS, HTML5, XML, Java Script, Ajax, J Query, Crystal Report 10, Sql Server 2008 and Acc Lagi

$750 USD dalam 15 hari
(1 Ulasan)

Dear employer, I'm having a hard time understanding employers requesting full blown demo before choosing a contractor. I'm sure you understand that making demo takes time and time is not free, however simple proje Lagi

$600 USD dalam 3 hari
(3 Ulasan)

If your requirement is as simple as you have mentioned then, it will be done in a day.

$250 USD dalam sehari
(0 Ulasan)

Kindly See my private Message

$300 USD dalam 10 hari
(0 Ulasan)