No announcements
Found 2852732 threads
-
1 VotesImporting the data from database to the excel sheet.
Is there any other solution for getting the complete set of records to a dataset or datatable and export it to the excel sheet.Answered | 6 Replies | 8581 Views | Created by bharat999 - Monday, May 23, 2011 4:05 AM | Last reply by Paul Zhou - Friday, May 27, 2011 4:58 AM
-
1 Votes
Problem to open Excel file with ‘.xlsb’ or ‘xlsx’ extension using C#.NET
Hi, I am trying to read an EXCEL file and it could have any extension (ex: xls | .xlsx | xlsb etc).Answered | 2 Replies | 8117 Views | Created by WantToBe_JediOfIT - Wednesday, August 31, 2011 4:25 PM | Last reply by Liliane Teng - Tuesday, September 6, 2011 9:12 AM -
0 Votes
Import Excel Sheet Data in SharePoint 2010 List
Hello zubairmashijullah, Please see the MSDN content at the site below: Walkthrough: Developing a Custom Application Using ...Answered | 3 Replies | 14167 Views | Created by zubairmasihullah - Tuesday, March 22, 2011 5:10 AM | Last reply by cjatms - Monday, March 28, 2011 6:52 PM -
1 Votes
Importing a excel 2007 binary (.xlsb) to a table in Access 2010
How to import Binary excel file (.xlsb) into MS Access.Answered | 9 Replies | 20673 Views | Created by Kevin T_Oberon - Wednesday, February 9, 2011 10:53 PM | Last reply by AjaySingh86 - Tuesday, January 24, 2017 6:14 PM -
0 Votes
read Data from excel to c#Datatable
Hi, <1>try the code, it's available and useful for me, //Create a new workbook Workbook workbook = new Workbook(); //Load a file ...Answered | 2 Replies | 2103 Views | Created by Anil kumarG - Wednesday, December 18, 2013 4:36 AM | Last reply by Ringinter - Wednesday, December 18, 2013 8:27 AM -
0 Votes
Retrieving excel sheet data using C#
Hope this may help you: Read excel through ...Answered | 2 Replies | 1819 Views | Created by N.Afache - Thursday, November 8, 2012 6:59 PM | Last reply by Linda00 - Friday, November 9, 2012 4:34 AM -
0 Votes
How do I fill an Excel spreadsheet with the contents of a DataTable?
Exporting and Exporting Data from SQL DB to Excel using C# Export DataSet or DataTable to Word Excel PDF and CSV ...Answered | 3 Replies | 6261 Views | Created by bhs67 - Tuesday, March 31, 2015 9:36 PM | Last reply by Simple Samples - Wednesday, April 1, 2015 2:55 AM -
2 Votes
Function to Import Excel Data to dataset in C#
I suggest you to try ZetExcel for .NET, is the fastest way that I have found to convert Excel files into C# and you don't even need to have Microsoft Excel ...Answered | 17 Replies | 82123 Views | Created by Javed Ahmed - Sunday, July 22, 2012 5:42 AM | Last reply by Tim Grey - Sunday, February 17, 2019 2:18 AM -
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 | 2486 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
Loading .xlsb file
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/Answered | 2 Replies | 2758 Views | Created by on7june - Wednesday, August 5, 2015 4:46 AM | Last reply by COZYROC - Wednesday, August 5, 2015 8:22 PM -
0 Votes
Xml 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 | 3393 Views | Created by VIVEK YJA - Wednesday, September 30, 2009 10:11 AM | Last reply by Derek Smyth - Wednesday, September 30, 2009 10:55 AM -
1 Votes
Data Import from Excel Multiple Sheets with a pattern of sheet names
Hi Rajiv, Based on your current scenario, we can add an expression like below in the Precedence Constraint (supposing the variable in the Variable Mapping tab of Foreach Loop Editor ...Answered | 5 Replies | 1297 Views | Created by Rajiv IR - Thursday, August 20, 2015 11:48 AM | Last reply by Katherine Xiong - Wednesday, August 26, 2015 7:26 AM -
1 Votes
how to insert datatable data into excel sheet (without providing column name)
http://stackoverflow.com/questions/6155182/excel-get-range-with-multiple-areas http://codeidol.com/csharp/c-sharp-in-office/Working-with-Ex ...Answered | 4 Replies | 26004 Views | Created by CupOverTheTable - Tuesday, August 7, 2012 6:14 AM | Last reply by CupOverTheTable - Tuesday, August 7, 2012 8:51 AM -
0 Votes
how to Import Excel Sheet data in SQL server
begin create table #t(col1 datatype,col2 datatype) insert into #t(col1,col2) SELECT col1,col2 FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel ...Answered | 3 Replies | 4136 Views | Created by dotnet.sql - Tuesday, March 6, 2012 12:51 AM | Last reply by duncandavenport - Tuesday, March 6, 2012 3:00 AM -
0 Votes
Need help with Importing These Kinds of Excel Data Sheets
I don't know C# that much, to do deep codes/.Answered | 7 Replies | 1262 Views | Created by Aditya Rathi - Wednesday, March 19, 2014 9:06 AM | Last reply by Aditya Rathi - Friday, March 21, 2014 8:19 AM -
0 Votes
How to manipulate excel file or sheet in C#.Net
in case you have excel installed in the server, where the application will run actually, then you can go for Oledb/ Excel connectors else it is better to use OpenXml as mentioned ...Answered | 4 Replies | 14841 Views | Created by HESHAM HEMDAN - Tuesday, September 4, 2012 7:47 AM | Last reply by Joon84 - Tuesday, September 4, 2012 9:47 AM -
0 Votes
Import data into datatable work once
Check the formatting of the cells in the specific column in Excel itself.Answered | 2 Replies | 528 Views | Created by labjac - Thursday, September 10, 2015 7:36 PM | Last reply by sterretje_K5 - Friday, September 11, 2015 8:09 AM -
0 Votes
import excel data to data set using asp.net C#
I'm not sure if I understood you correctly, but I presume that each of those 10 columns should be imported into a separate data table and those sub columns represent the columns for ...Answered | 3 Replies | 1274 Views | Created by Sudeesh IG - Thursday, September 24, 2015 10:59 AM | Last reply by Kristin Xie - Friday, September 25, 2015 8:40 AM -
1 Votes
Importing data from an Excel file.
Kev, you were right about the Sheet thing, and Raja you showed me that I was creating another data grid view by mistake. xxxxxxx =DAnswered | 4 Replies | 4859 Views | Created by Aaron_Sharp - Friday, January 7, 2011 2:36 PM | Last reply by Aaron_Sharp - Friday, January 7, 2011 7:42 PM -
0 Votes
Export Data from Datatable into Excel
For this kind of requirement you could use an OLEDB connection in order to generate a file or an OpenXML SDK or this excel ...Answered | 4 Replies | 4371 Views | Created by Brijendra Pandey - Wednesday, August 10, 2011 9:32 AM | Last reply by Theirligh - Monday, April 14, 2014 8:25 AM - Items 1 to 20 of 2852732 Next ›
No announcements
