No announcements
Found 2561958 threads
-
0 VotesDelete sheet from the excel
The only way is by using a Script Task (or may be by using Third Party components).Answered | 3 Replies | 3234 Views | Created by SuperMan555 - Friday, March 1, 2013 6:31 PM | Last reply by SSISJoost - Monday, March 4, 2013 6:31 AM
-
3 Votes
Delete a existing excel sheet from ssis
The following is a method which I've used previously: First put an empty template Excel file in a "template" folder.Answered | 3 Replies | 7724 Views | Created by Murali dhar - Thursday, August 28, 2014 3:13 AM | Last reply by Valentino Vranken - Thursday, August 28, 2014 6:27 AM -
0 Votes
How to delete excel Sheets.
Check the commercial COZYROC Excel Task.Answered | 3 Replies | 2688 Views | Created by Sreepi - Thursday, October 15, 2015 11:17 AM | Last reply by COZYROC - Saturday, October 17, 2015 3:38 AM -
0 Votes
How to delete an Excel sheet with a specific name from a script task in SSIS
I also find the flags to control the interaction from Excel.Answered | 15 Replies | 13483 Views | Created by Felix Jiang - Thursday, July 16, 2009 10:57 AM | Last reply by Felix Jiang - Thursday, July 16, 2009 5:08 PM -
0 Votes
Delete specific columns in Excel document (on every sheet)
>>I want to remove column 10 and 12 (J and L) on every sheet before creating the actual file, "second.xlsx".Answered | 3 Replies | 871 Views | Created by Jonas Andersson - Sunday, November 15, 2015 12:01 AM | Last reply by David_JunFeng - Wednesday, November 18, 2015 1:16 AM -
0 Votes
Delete Common Sheet called "Spec" from 800 excel worksheets
See the other thread titled Delete Common Sheet called "Spec" from 800 excel worksheets.Answered | 6 Replies | 2793 Views | Created by bunty_1244 - Tuesday, April 3, 2012 9:32 PM | Last reply by Hans Vogelaar MVP - Wednesday, April 4, 2012 5:28 AM -
0 Votes
Generate Excel sheet from DataSet
But I want Oledb for the connection to excel and want to save it.Answered | 6 Replies | 6142 Views | Created by MithranM - Friday, April 13, 2012 1:57 PM | Last reply by Green823 - Tuesday, April 17, 2012 4:03 AM -
1 Votes
how to delete all empty rows from a excel sheet using Microsoft.Office.Interop.Excel
+ 1 Sophia :) Nicely done @Seema: You have seen one way (The looping way) to delete the rows.Answered | 2 Replies | 20833 Views | Created by Sharma Seema - Wednesday, September 4, 2013 8:24 AM | Last reply by Siddharth Rout - Friday, September 6, 2013 3:42 AM -
0 Votes
how to delete first three rows in excel sheet whenever import the excel sheet into database using ssis
You could use a range query: SELECT * FROM ...Answered | 1 Replies | 6219 Views | Created by SSQL123 - Monday, April 15, 2013 7:14 AM | Last reply by SSISJoost - Monday, April 15, 2013 7:21 AM -
0 Votes
Sheet Names from EXCEL
I want to read the sheetnames from a excel spread sheet and i want it to appear in the same order as they exist in the spread sheet.Answered | 1 Replies | 12424 Views | Created by sridr1 - Friday, May 30, 2008 5:46 AM | Last reply by Kiran Polimetla - Friday, October 17, 2008 10:57 AM -
9 Votes
Deleting a row in excel sheet using C#
Ultimately I am trying to clean up an excel sheet in order to extract data from and dump it into a csv file.Answered | 5 Replies | 79164 Views | Created by livehed - Friday, January 6, 2006 7:02 AM | Last reply by Joe Zyirek - Tuesday, February 12, 2013 12:09 AM -
0 Votes
regarding ssis - Read multiple excel sheets from one excel file
Using foreach loop container for ado.net enumerator, get the excel sheets.Answered | 3 Replies | 1751 Views | Created by Koteswararao Bellam - Sunday, September 13, 2015 5:48 PM | Last reply by SupriyaT - Monday, September 14, 2015 10:14 AM -
0 Votes
Read from Multiple excel sheet & insert in to list
Hi, According to your description, you might want to extract values from Excel files and insert into SharePoint List.Answered | 2 Replies | 2524 Views | Created by vickychinna - Tuesday, November 11, 2014 8:53 PM | Last reply by Patrick_Liang - Wednesday, November 12, 2014 7:48 AM -
0 Votes
Write Query to update records from excel sheet
Hi Muhammad Based on my understanding, you want to update the table Department with the data in an excel sheet, right?Answered | 6 Replies | 1408 Views | Created by MM from AUS - Monday, November 10, 2014 3:23 AM | Last reply by Visakh16 - Monday, December 8, 2014 6:48 AM -
0 Votes
3 excel sheets load into one excel sheet
Ask a Question):Answered | 1 Replies | 1862 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 -
2 Votes
Import data from excel sheet
select excel file as Source And write down Select Statement (SQL command)--> Select * from [yourTabname$A5:A10]----> it will select one column ...Answered | 5 Replies | 2605 Views | Created by sarat sahoo - Monday, November 26, 2012 11:32 AM | Last reply by santhubt - Monday, November 26, 2012 2:40 PM -
0 Votes
how can we restrict user not to delete records in excel sheet
Hi qasimidl, One thing you should notice: We cannot restrict user behaviors in Excel workbook/spreadsheet from SharePoint.Answered | 6 Replies | 749 Views | Created by qasimidl - Wednesday, April 29, 2020 2:46 PM | Last reply by Chelsea Wu - Wednesday, May 6, 2020 1:17 AM -
2 Votes
How to Overwrite an Excel sheet using SSIS or How to Delete data Before Inserting into Excel Sheet
Hi Santhosh, You can used the below mentioned Steps to perform the deletion in Excel: 1.Answered | 10 Replies | 31179 Views | Created by Santosh.pandyala - Friday, August 3, 2012 12:01 PM | Last reply by Ramasubramanian. S (Partner) - Tuesday, August 28, 2012 5:21 PM -
0 Votes
Insert selected column from multiple excel sheet ????
Dear Sir, I have idea of loading al the diffrent excel shee in diffrent table using foreach loop will explain or post me steps or any link where i wil ...Answered | 8 Replies | 3053 Views | Created by Vipin jha - Thursday, July 5, 2012 8:48 AM | Last reply by Vipin jha - Friday, July 6, 2012 5:17 AM -
0 Votes
Delete blank rows from excel
This will delete the row with only one cell blank?Answered | 6 Replies | 2269 Views | Created by zaveri cc - Wednesday, December 18, 2013 5:10 PM | Last reply by zaveri cc - Thursday, December 19, 2013 3:37 PM - Items 1 to 20 of 2561958 Next ›
No announcements
