No announcements
Found 1264438 threads
-
0 VotesExcel Sheet change event
However, I would suggest you use the Workbook.Saved Property to find out if anything changed in excel.This property gets or sets a value ...Answered | 2 Replies | 5758 Views | Created by ChiragP - Wednesday, June 6, 2012 6:50 PM | Last reply by ChiragP - Thursday, June 7, 2012 2:00 PM
-
0 Votes
Changing sheet name in excel exports
http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports There is ...Answered | 1 Replies | 5276 Views | Created by Sandhya Kacham - Thursday, April 28, 2011 12:01 PM | Last reply by Josh Ashwood - Thursday, April 28, 2011 12:51 PM -
0 Votes
How to change the Sheet Name of Exported Excel sheet in RDLC
Hi Suresh Sankaran, According to your description, you want to change the sheet name when exporting report to excel.Answered | 2 Replies | 10120 Views | Created by Suresh Sankaran - Monday, April 18, 2016 9:17 AM | Last reply by Xi Jin - Tuesday, April 19, 2016 6:30 AM -
1 Votes
Is it possible to change excel sheet as culture specific?
If this user then changes it to 25,78 and sends the workbook back to you, you'll see 25.78.Answered | 1 Replies | 6962 Views | Created by Nandhini.M - Monday, December 24, 2012 9:41 AM | Last reply by Hans Vogelaar MVP - Monday, December 24, 2012 11:06 AM -
0 Votes
3 excel sheets load into one excel sheet
Ask a Question):Answered | 1 Replies | 1860 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
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 | 5408 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 -
3 Votes
Lock/Unlock excel sheet
Hi, In fact, if you protect an worksheet in Excel, you cannot access and change the data in your worksheet.Answered | 6 Replies | 1371 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
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 | 6887 Views | Created by KIRAN KUAMR - Friday, April 22, 2011 5:12 PM | Last reply by Reza Raad - Friday, April 22, 2011 7:14 PM -
0 Votes
Excel Objects (Sheets)
The sheets have already been coded.Answered | 4 Replies | 840 Views | Created by Deddend1 - Friday, March 13, 2015 2:59 PM | Last reply by Lanlan0901 - Thursday, March 19, 2015 5:17 AM -
2 Votes
Excel sheet to database
This is the format: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\MyExcelFile1.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1"; Please mark the post ...Answered | 3 Replies | 2595 Views | Created by sql.anandan - Saturday, July 21, 2012 11:11 AM | Last reply by SSISJoost - Saturday, July 21, 2012 11:39 AM -
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 | 4354 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 -
0 Votes
Problem with ( and ) in Excel Sheet name
Hi Malhoosh1, Please try this method as below: SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0; ...Answered | 4 Replies | 5644 Views | Created by SB User - Sunday, March 11, 2012 1:54 PM | Last reply by SB User - Thursday, March 15, 2012 11:32 AM -
0 Votes
Can change the bitmap in a bitmap control
You need to use the image list functions to change those images.Answered | 4 Replies | 911 Views | Created by GregaryB - Saturday, February 13, 2016 6:56 PM | Last reply by VisualEleven - Monday, February 15, 2016 9:34 AM -
0 Votes
issue with the excel with multiple sheets
While, you can also check ...Answered | 6 Replies | 4197 Views | Created by Eswararao C - Wednesday, May 2, 2012 7:58 AM | Last reply by Eswararao C - Wednesday, May 2, 2012 12:23 PM -
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 | 3233 Views | Created by SuperMan555 - Friday, March 1, 2013 6:31 PM | Last reply by SSISJoost - Monday, March 4, 2013 6:31 AM -
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 | 2588 Views | Created by Koritala - Monday, June 17, 2013 6:23 PM | Last reply by SathyanarrayananS - Tuesday, June 18, 2013 3:05 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 | 3295 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 | 1119 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 | 3766 Views | Created by litusahoo - Tuesday, February 22, 2011 4:30 AM | Last reply by Neddy Ren - Wednesday, February 23, 2011 8:44 AM -
2 Votes
Change name of Excel Sheet on export
Hi, try this: ExcelFile file = ExcelFile.Load("Workbook.xlsx"); file.Worksheets["Old Name"].Name = "New ...Answered | 3 Replies | 3689 Views | Created by Jonathan Du - Tuesday, July 12, 2011 12:49 PM | Last reply by Heeut - Wednesday, April 16, 2014 11:57 AM - Items 1 to 20 of 1264438 Next ›
No announcements
