No announcements
Found 3402106 threads
-
0 Votesread Data from excel to c#Datatable
May not be the best way to do it but here is what I do and it works: _File is a string that holds the full path and file name of the excel file _Data is ...Answered | 2 Replies | 1928 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
Create Excel File and Populate With DataTable Value
You can refer this too http://curah.microsoft.com/291817/write-value-to-excel-without-using-oledb chanmm chanmmAnswered | 5 Replies | 4783 Views | Created by mIN-MADIN - Thursday, May 21, 2015 1:31 PM | Last reply by mIN-MADIN - Tuesday, May 26, 2015 9:50 AM -
0 Votes
Loading data from Excel to DataTable
Hi, You can automate Microsoft Excel using .net and retrieve a two-dimensional array of values for multiple cells at once by using the ...Answered | 8 Replies | 5290 Views | Created by RM123 - Tuesday, February 3, 2009 10:25 AM | Last reply by Sarvesh-Kushwaha - Wednesday, February 29, 2012 1:21 AM -
2 Votes
Function doesn't return a value on all code paths
"Exit Function" (and "Exit Sub", etc.) are holdovers from VB6, only there for legacy reasons.Answered | 4 Replies | 544 Views | Created by Hugh Self Taught - Wednesday, February 5, 2020 9:57 AM | Last reply by Dave Doknjas - Wednesday, February 5, 2020 3:06 PM -
1 Votes
Read All Data From Excel at one instance in unit testing.
One data from function returned value (data table or data set) and another data's from .csv file.Answered | 8 Replies | 6273 Views | Created by Pradeep.j - Thursday, May 24, 2012 12:16 PM | Last reply by Pradeep.j - Friday, June 1, 2012 10:21 AM -
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 automation ...Answered | 4 Replies | 4189 Views | Created by Brijendra Pandey - Wednesday, August 10, 2011 9:32 AM | Last reply by Theirligh - Monday, April 14, 2014 8:25 AM -
79 Votes
Reading Excel From C#
I use a best tool for creating an Excel Spreadsheet with C#, it can reading and writing to excel 2007 or excel 2010 from c#.Answered | 78 Replies | 1069367 Views | Created by NewtoCsharp2008 - Tuesday, October 11, 2005 10:49 PM | Last reply by Thari777 - Monday, May 28, 2012 10:59 AM -
1 Votes
How to Improve the performance of reading data from excel and writing to datatable
Hi, you can also try this approach: Dim xlw = ExcelFile.Load(FileName) Dim xls = xlw.Worksheets(_SheetNo) Dim dataTable = xls.CreateDataTable(New ...Answered | 3 Replies | 3468 Views | Created by Ravi_P - Saturday, May 21, 2011 7:14 AM | Last reply by ryguy72 - Tuesday, October 8, 2013 7:18 PM -
0 Votes
Export Data from Datatable into Excel
Hello, you can try to export DataTable to Excel with this Excel C# library that has very good performance regarding CPU and memory.Answered | 3 Replies | 10532 Views | Created by Brijendra Pandey - Monday, August 8, 2011 9:57 AM | Last reply by Neil.Harrison72 - Wednesday, May 16, 2012 11:11 AM -
1 Votes
Export dataTable to Excel from C#
I neet to export DataTable to excel.Answered | 11 Replies | 79018 Views | Created by trib_had - Thursday, March 26, 2009 8:24 AM | Last reply by EMB91909 - Tuesday, April 3, 2012 4:24 PM -
0 Votes
read from datatable
If he looks at the table in the debugger it will give the row values AND the column names.Answered | 8 Replies | 886 Views | Created by arkiboys - Thursday, January 17, 2013 9:26 AM | Last reply by CountryStyle - Thursday, January 17, 2013 2:52 PM -
0 Votes
read excel values
.. problem here is i'm not able to fetch all the empids from excel in this query Thats ...Answered | 8 Replies | 930 Views | Created by chelseasadhu - Saturday, June 28, 2014 4:43 PM | Last reply by Visakh16 - Tuesday, July 1, 2014 10:31 AM -
1 Votes
Export data from DataTable to an excel
Hi IMSunny, Using C#, you can get a taxonomy metadata field value like this: foreach (SPListItem item in listColl) { DataRow dr = ...Answered | 2 Replies | 3894 Views | Created by IMSunny - Thursday, February 13, 2014 8:58 AM | Last reply by Matthew Yarlett - Friday, February 14, 2014 5:23 AM -
0 Votes
How to read from excel(2007 format) file and store the data into datatable
Hi, How to read from excel(2007 format) file and store the data into datatable?Answered | 1 Replies | 3494 Views | Created by VIVEK YJA - Tuesday, September 22, 2009 2:28 PM | Last reply by Stephen Cleary - Tuesday, September 22, 2009 5:22 PM -
0 Votes
Read Data from Excel
For help in reading from MS word, visit theAnswered | 1 Replies | 566 Views | Created by Nila123 - Tuesday, November 12, 2013 6:31 PM | Last reply by Sheng Jiang 蒋晟 - Tuesday, November 12, 2013 7:08 PM -
0 Votes
C# and trying to read from excel file
It is much easier to use than Excel Automation and it is much faster - it doesn't rely on Excel app so it is ideal for server side usage.Answered | 12 Replies | 9071 Views | Created by StevenIB - Wednesday, January 20, 2010 3:27 AM | Last reply by CikaPero - Wednesday, January 27, 2010 9:44 AM -
2 Votes
Reading Excel Sheet
Hi, Use the below code to read Data from Excel Sheet if (!Answered | 5 Replies | 3747 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 -
0 Votes
Reading Data from Excel into VB.net
It requires EasyXLS library to read excel file in VB.NET.Answered | 10 Replies | 81890 Views | Created by Bilbo0a - Thursday, June 6, 2013 5:51 AM | Last reply by ryguy72 - Thursday, May 1, 2014 1:15 AM -
0 Votes
Problem reading big number from Excel file in C#?
But If Excel file is closed, then handling data through C# doesn't create any problem.Answered | 13 Replies | 10916 Views | Created by Rana76 - Thursday, March 21, 2013 1:04 PM | Last reply by MarioMJunior - Tuesday, November 18, 2014 1:53 PM -
1 Votes
Export datatable in memory to excel
For example the Excel worksheet (ws) has no InsertDataTable function in my VB 2008 (or at least IntelliSense does not recognize that) ' Insert the data ...Answered | 10 Replies | 6102 Views | Created by dj_rakasz - Sunday, January 10, 2010 8:21 PM | Last reply by CikaPero - Friday, January 15, 2010 10:48 AM - Items 1 to 20 of 3402106 Next ›
No announcements
