No announcements
Found 424168 threads
-
0 VotesXml data Import to EXCEL Sheet
http://office.microsoft.com/en-us/excel/HP010423511033.aspx http://support.microsoft.com/default.aspx/kb/305795www.dsmyth.net | www.dsmyth.net/wikiAnswered | 1 Replies | 3486 Views | Created by VIVEK YJA - Wednesday, September 30, 2009 10:11 AM | Last reply by Derek Smyth - Wednesday, September 30, 2009 10:55 AM
-
0 Votes
Regarding Excel sheet to xml conversion
Hi Ranjana, You can use OPEN XML SDK to read excel files directly into your pipeline component.Answered | 3 Replies | 880 Views | Created by Ranjana_Torreti - Tuesday, September 1, 2015 4:49 AM | Last reply by SMSVikasK - Tuesday, September 1, 2015 10:12 PM -
0 Votes
Dupilcate excel sheet openxml
Workbook workbook = new Workbook(); workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx"); //get the sheet that you want to copy Worksheet sheet1 = ...Answered | 2 Replies | 900 Views | Created by José A M Pacheco - Monday, September 26, 2016 10:03 PM | Last reply by Ashok Kumar_ - Wednesday, September 28, 2016 3:36 AM -
0 Votes
3 excel sheets load into one excel sheet
Ask a Question):Answered | 1 Replies | 1843 Views | Created by chandra prakash reddy - Wednesday, November 25, 2015 6:34 AM | Last reply by Mike Laughlin - Wednesday, November 25, 2015 1:32 PM -
0 Votes
Error during open the excel sheet
You can try to validate that corrupted excel file using Open XML SDK productivity tool.Answered | 1 Replies | 1523 Views | Created by udayakumar subramaniyan - Tuesday, September 23, 2014 1:48 PM | Last reply by Office2007 Developer - Tuesday, September 23, 2014 10:05 PM -
0 Votes
Load sheets in Excel
Assuming my excel files are located in d:\data\ and my excel documents as test01.xls,test02.xls,test03.xls Note : i am introducing one more table in addition to ...Answered | 3 Replies | 4340 Views | Created by Manu_vmr - Saturday, October 3, 2009 1:41 PM | Last reply by Nik - Shahriar Nikkhah - Sunday, October 4, 2009 8:18 PM -
2 Votes
Saving Excel file as xml
Also, you can refer to this page: http://www.codeproject.com/Articles/296288/Excel-Add-in-for-Exporting-Excel-data-to-XML Provides a ...Answered | 2 Replies | 1386 Views | Created by Er. Keshav - Thursday, June 20, 2013 7:54 AM | Last reply by Howie.R - Wednesday, June 26, 2013 7:33 AM -
0 Votes
Delete sheet from the excel
The only way is by using a Script Task (or may be by using Third Party components).Answered | 3 Replies | 3217 Views | Created by SuperMan555 - Friday, March 1, 2013 6:31 PM | Last reply by SSISJoost - Monday, March 4, 2013 6:31 AM -
0 Votes
Hide Excel sheets
all i want to do is: i have an excel workbook with two sheets i navigate to the second sheet by click on a button from the first sheet i want to ...Answered | 11 Replies | 5396 Views | Created by mohammed abdel-aziz - Wednesday, November 3, 2010 12:53 PM | Last reply by G North - Sunday, November 7, 2010 12:25 PM -
0 Votes
issue with the excel with multiple sheets
While, you can also check ...Answered | 6 Replies | 4185 Views | Created by Eswararao C - Wednesday, May 2, 2012 7:58 AM | Last reply by Eswararao C - Wednesday, May 2, 2012 12:23 PM -
2 Votes
Excel sheet reading error.
Whenever i tried to load the excel sheets data into a sql table i get the error like this [Excel Source [47]] Warning: The external ...Answered | 2 Replies | 2561 Views | Created by Koritala - Monday, June 17, 2013 6:23 PM | Last reply by SathyanarrayananS - Tuesday, June 18, 2013 3:05 AM -
0 Votes
Copy a Sheet from an Excel to another ¿is this possible?
f=255&MSPPError=-2147217396 We also could achieve that through Open XML SDK, just base on the source excel sheet to add a new sheet ...Answered | 1 Replies | 828 Views | Created by eariel - Wednesday, June 17, 2015 7:25 AM | Last reply by Starian chen - Thursday, June 18, 2015 6:17 AM -
0 Votes
how to load excel sheet
If you have 3 fixed sheets that needs to be populated from 3 different SQL table, i would make a SMAPLEEXCELFIEL.xls insted of making the sheets on the fly.Answered | 7 Replies | 3281 Views | Created by v60 - Tuesday, February 28, 2012 5:07 AM | Last reply by Nik - Shahriar Nikkhah - Wednesday, February 29, 2012 4:35 PM -
0 Votes
excel multi-sheets
So the question is: is it a good idea to have one dataflow with several excel source (one for each sheet) and several ole db destinations ...Answered | 6 Replies | 1108 Views | Created by arkiboys - Saturday, February 13, 2016 12:01 PM | Last reply by arkiboys - Friday, February 26, 2016 2:23 PM -
1 Votes
Filtering data in a excel sheet
Here are two samples about filtering data from excel files: Excel Adapter for ...Answered | 3 Replies | 3754 Views | Created by litusahoo - Tuesday, February 22, 2011 4:30 AM | Last reply by Neddy Ren - Wednesday, February 23, 2011 8:44 AM -
0 Votes
multiple excel sheets
you can use Execute SQL Task in SSIS 2005 to do what I proposed with OpenRowSet, first you should read all excel sheet names in an ...Answered | 4 Replies | 6870 Views | Created by KIRAN KUAMR - Friday, April 22, 2011 5:12 PM | Last reply by Reza Raad - Friday, April 22, 2011 7:14 PM -
2 Votes
Reading Excel Sheet
Hi, Use the below code to read Data from Excel Sheet if (!Answered | 5 Replies | 4002 Views | Created by Bhaskar Das - Thursday, December 15, 2011 5:52 AM | Last reply by Syed Shakeer Hussain - Thursday, December 15, 2011 10:59 AM -
3 Votes
Lock/Unlock excel sheet
So quickly make use of the foremost eSoftTools Excel Password Recovery Software that pull out the lost password of Excel file supported all versions included- 97, ...Answered | 6 Replies | 1359 Views | Created by Deb_chatt - Saturday, July 12, 2014 6:35 AM | Last reply by rondevide - Thursday, September 6, 2018 6:56 AM -
0 Votes
excel sheet(each sheet) loding into text fle
Vijay, If you are sure of your sheet names then three DFT's with select query for each sheet (as given below fr a) will ...Answered | 2 Replies | 2756 Views | Created by v60 - Wednesday, February 15, 2012 6:58 AM | Last reply by Eileen Zhao - Tuesday, February 21, 2012 12:38 PM -
0 Votes
Rotate the Text in a Excel sheet
using (SpreadsheetDocument excel = SpreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook)) { WorkbookPart wbp = ...Answered | 3 Replies | 1221 Views | Created by Nejox - Tuesday, July 12, 2016 2:34 PM | Last reply by Nejox - Wednesday, July 13, 2016 8:15 AM - Items 1 to 20 of 424168 Next ›
No announcements
