Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
ado.net-excel
- Page 1
Extract Tabular Data from PDF Images using Hugging Face Table Transformer
Programming
Computer Science
2 Months Ago
by usmanmalik57
… save the table as CSV. So, let's begin without
ado
. ## Installing and Importing Required Libraries The first step is to…('output.csv','w') as result_file: wr = csv.writer(result_file, dialect='
excel
') for row, row_text in data.items(): wr.writerow(row_text) write_csv…
Re: what's the correct way of learning programming?
Programming
2 Months Ago
by tinstaafl
… are a great many areas to explore and most languages
excel
in only some of those areas. If your interest is… as a hobby, you could do far worse than vb.
net
. Not only is it a robust, plain language coding language…
Re: Get error please help me the server threw an exception.
Programming
Software Development
2 Months Ago
by tinstaafl
Have you tried looking at the answers on this page? [Click Here](https://stackoverflow.com/questions/973206/what-causes-error-hresult-0x80010105-rpc-e-serverfault)
Re: Simple database backup? and exporting to excel file?
Programming
Software Development
14 Years Ago
by kvprajapati
[b]>Is it just simplier if I would write my data on a text file and then export it to my form whenever the user wants?[/b] Yes. CSV files can be read/update by the
ADO
.
NET
,
excel
as well as file system classes.
Re: Excel Interop
Programming
Software Development
14 Years Ago
by kvprajapati
[b]>Can I avoid referencing the Interop library Microsoft.Office.Interop,
Excel
?? Is there another way to link to
Excel
?[/b] [URL="http://www.knowdotnet.com/articles/exceldatasource.html"]
ADO
.
NET
[/URL] and [URL="http://en.wikipedia.org/wiki/Office_Open_XML"]OpenXML[/URL].
Display Excel data in a DataGridView
Programming
Software Development
9 Years Ago
by djjeavons
…code snippet demonstrates how to use
ADO
.
NET
to read the contents of a Microsoft
Excel
Worksheet. This snippet also demonstrates the…, EventArgs e) { OpenFileDialog openDialog = new OpenFileDialog(); openDialog.Filter = "
Excel
|*.xlsx"; if (openDialog.ShowDialog() == DialogResult.OK) { excelFileTextBox.Text =…
Re: Open/ modify Excel through ADO.net
Programming
Software Development
13 Years Ago
by Baldur Levesque
stuck with
ado
.
net
for opening
excel
, the way is slowly. you can use a [URL="http://www.e-iceblue.com/Introduce/
excel
-for-
net
-introduce.html"]c#
excel
component[/URL], may useful to you named Spire.XLS.
Re: View Excel spreadsheet in ASP.net with dynamic labels
Programming
Web Development
10 Years Ago
by LastMitch
…;I want to view this same spreadsheet in a ASP.
NET
page, with the textboxes filled in. The spreadsheet is so… be the way to go. I never actually used **ASP.
net
Excel
** but I actually did used PHP version (**PHPExcel**) of it…. You can take a look at it here **ASP.
net
Excel
**: http://epplus.codeplex.com/
Saving Excel Spreadsheet using ADO.net gives inconsistent results
Programming
Software Development
17 Years Ago
by peterbyrne
… I succesfully managed to do this using the .
NET
COM interop
Excel
collection of interfaces but even though this works beautifully… if I could achieve the same results using the
ADO
.
net
classes. For the purpose of this query please regard…table'. Having coded this I find that the Jet4.0
Excel
Database engine does not interpret the 'table' in the…
Re: how to export data from accees to excel on ASP.NET?
Programming
Web Development
10 Years Ago
by du_1
…here is my solution to export data to
Excel
with a [.
NET
Excel
library](https://github.com/spirecomponent/.NETExcelLibrary) //…DataTable dataTable = new DataTable(); adapter.Fill(dataTable); //Create
Excel
Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[…
connecting excel to vb.net
Programming
Software Development
16 Years Ago
by apchidara
hi every one I have a lot of
excel
data sheets and I need to work with them . how can I connect my code with the
excel
files . is it the same as
ADO
.
net
while u do with access? please help me or send me a link about
EXCEL
ANV VB.
NET
CONNECTIVITY i al so lost . thanks
Re: connecting excel to vb.net
Programming
Software Development
16 Years Ago
by Hamrick
Here's a function for loading an
excel
spreadsheet using
ADO
.
NET
. It's in C#, but you should know how to ….4.0;Data Source=" + filename + ";Extended Properties=\"
Excel
8.0;HDR=" + ( hasHeader ? "Yes" : "No…
building excel file gives memory out of exception
Programming
Web Development
14 Years Ago
by anishmohan
… export huge amount of data from
ado
.
net
datatable(which i get by db query) to
excel
. I tried the following way : …1. Create
excel
object with workbook/worksheet @ server side… this way we can write to csv file...not to
excel
... Does anybody know how to handle this situation. Can …
Re: How to extract all data from a excel file and copy it to another excel file
Programming
Software Development
9 Years Ago
by du_1
… it can be helpful.(P.S. You have to add [.
NET
Excel
.dll](http://www.e-iceblue.com/Introduce/free-xls-component…
Re: List from OpenXML Excel Column Headers
Programming
Software Development
13 Years Ago
by David Sanchez
for opening xml
excel
column header, you can use a[URL="http://www.e-iceblue.com/Introduce/
excel
-for-
net
-introduce.html"] vb.
net
excel
[/URL]component. It's named Spire.XLS. Hope help to you.
Re: import excel file to datagridview
Programming
Software Development
9 Years Ago
by djjeavons
… and MIN on the data. Can I suggest you use
ADO
.
NET
for this, much better than using COM for this scenario… (https://www.daniweb.com/software-development/csharp/code/492766/display-
excel
-data-in-a-datagridview) shows how to do a basic… SQL select on an
Excel
sheet which you can then combine MAX etc. statements with…
Re: import excel file to datagridview
Programming
Software Development
9 Years Ago
by djjeavons
… you too does exactly that. It uses
ADO
.
NET
to query the contents of an
Excel
file (displays the worksheets in a combo…
Re: import values from excel to vb application
Programming
Software Development
10 Years Ago
by Reverend Jim
… to another
Excel
file by using the
Excel
Application object. This example uses
ADO
.
NET
, however, …
Excel
file Dim xls As New
Excel
.Application Dim sheet As
Excel
.Worksheet Dim book As
Excel
.Workbook 'Create an
Excel
… you will be left with one orphaned
Excel
.exe task for every time you run…
Re: How can i retrieve the data from access database lin to excel with VB ?
Programming
Software Development
13 Years Ago
by G_Waddell
… use the Access DB? you can link directly to the
Excel
document as if it was a database table. Try looking….com[/URL] for the
excel
version you are using. Also you can google
ADO
.
net
and
Excel
or VB.
Net
and
Excel
and get loads of…
Re: c sharp export datagridview to excel 2013!
Programming
Software Development
9 Years Ago
by djjeavons
Hi What is the actual error that you get? Also, you might want to consider using
ADO
.
NET
to do this which would remove the dependency on using the
Excel
Interop libraries. I can provide an example if that is of interest to you.
Re: Exporting from VB.Net to Microsoft Exel 2007
Programming
Software Development
13 Years Ago
by kvprajapati
[b]>Exporting from VB.
Net
to Microsoft
Excel
2007. Can someone post a code to do the above task. thank you[/b] Two ways: 1. Use
ADO
.
NET
OleDb data provider. 2. Office InterOp API
Re: import values from excel to vb application
Programming
Software Development
10 Years Ago
by GeekPlease
Good day Jim, I already seen how to connect to
excel
using
ADO
.
NET
and OLEDB but can you explain what is the good choice between the two? What are the pros and cons of each connection?
Re: extracting data from listbox to excel file please help
Programming
Software Development
13 Years Ago
by kvprajapati
Two ways to do so: 1. Use Office-InterOp library. 2. Use
ADo
.
NET
OleDB provider.
Re: Hide excel columns from column K to the right using vb.net
Programming
Software Development
9 Years Ago
by cgeier
…:\Temp\Book1.xlsx", ColumnVisibility.Show) **Resources:** [VB.
NET
Excel
](http://www.dotnetperls.com/
excel
-vbnet) [How to select cells/ranges by using…
Re: How to export excel in c#.net on button click
Programming
Web Development
11 Years Ago
by EterS
Need to export data from database to
Excel
? or
Excel
to Database? If the former, I think …/UploadFile/83fe73/solutions-to-export-data-from-database-to-
excel
-in-C-Sharp/ may give you some suggestions.…solution with a commercial [
Excel
library](http://www.squidoo.com/
net
-
excel
-api) to export data from
Excel
sheet to datatable. //Load…
Re: How to save copied data from a website of to an excel sheet using C#
Programming
Software Development
9 Years Ago
by du_1
Will .
NET
Excel
API which supports converting .asp page to
Excel
file can sovle your problem?
Re: Export DataSet to Excel
Programming
Software Development
8 Years Ago
by du_1
… works. Before you can run the code, remember to reference .
net
Excel
dll from: http://spreadsheet.codeplex.com/ //connect database OleDbConnection connection….Fill(dataSet); DataTable t = dataSet.Tables[0]; //export datatable to
excel
Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; sheet…
Re: Export DataSet to Excel
Programming
Software Development
9 Years Ago
by Dietmar Paul
I use this DLL from here: http://www.export2excel.
net
/
excel
/ It is incredibly tiny and fast!
Hello from a newbie
Community Center
Say Hello!
9 Years Ago
by Cybernard
… an IT expert. I've been using VBA since
Excel
supports it (
Excel
5-1995?). I work here as a school administrator… now in the process of upgrading to VB.
Net
and MS SQL Server, using
ADO
.
net
. In fact, I have to re-write… use tricks like VB.Left$(MyString,2) for instance. VB.
net
= MyString.Substring(MyString.Length - 2, 2) and so on. If…
Re: Microsoft.Office.Interop Word/Excel Manipulation
Programming
Software Development
14 Years Ago
by BarbaMariolino
… is not best way to work with
Excel
in .
NET
. You can try using GemBox .
NET
Excel
component which is free for commercial use… a list of reasons why GemBox.Spreadsheet is better then
Excel
Interop and
Excel
Automation [url]http://www.gemboxsoftware.com…
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC