Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
excel_oledb
- Page 1
Hi everyone, I'm clarawilliams
Community Center
Say Hello!
1 Day Ago
by clarawilliams
As a seasoned marketing professional with a keen eye for technology trends, I excel in amplifying the presence and profitability of custom software development companies, and Artificial Intelligence development companies. With a solid background in digital marketing strategies and a deep understanding of the tech landscape, Clara crafts compelling …
Re: Hi everyone, I'm clarawilliams
Community Center
Say Hello!
1 Day Ago
by pritaeas
Welcome.
Extract Tabular Data from PDF Images using Hugging Face Table Transformer
Programming
Computer Science
2 Months Ago
by usmanmalik57
In a previous article, I explained [how to extract tabular data from PDF image documents using Multimodal Google Gemini Pro](https://www.daniweb.com/programming/computer-science/tutorials/541449/pdf-image-table-extractor-web-app-with-google-gemini-pro-and-streamlit#post2296083). However, there are a couple of disadvantages with Google Gemini Pro. …
Re: Design vs. Coding
Programming
Software Development
2 Months Ago
by Dani
Are you implying that a single person would constantly rotate across positions involving software architect, coder, writing documentation, and doing QA? I'm not a fan of this strategy. Firstly, different people have different strengths and weaknesses. You want to put each person in a position in which they will thrive at doing what they're best at.…
Re: what's the correct way of learning programming?
Programming
2 Months Ago
by tinstaafl
I would suggest first off is examining exactly what you want to do with your programming. There 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 it also includes a WYSIWYG gui editor …
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: Excel range to string array
Programming
Software Development
9 Years Ago
by ddanbe
Anothr approach could be [this](http://csharp.net-informations.com/excel/csharp-excel-oledb.htm) If you still want your string array, you could get it out of the DataGridView.
Re: Import Excel Data to DataGrideView
Programming
Software Development
6 Years Ago
by ddanbe
Suggest you have a look at[ this article](http://csharp.net-informations.com/excel/csharp-excel-oledb.htm)
Re: C# excel insert
Programming
Software Development
8 Years Ago
by JOSheaIV
Are you trying to keep a running counter that every new item you index is on a new row? (kind of like you would do if you inserted into a SQL server database)? If the code isn't working you may want to check this link http://csharp.net-informations.com/excel/csharp-excel-oledb-insert.htm It appears to be doing exactly what you are trying to do …
Re: transfer Data to Datagridview from another Form
Programming
Software Development
6 Years Ago
by ddanbe
You could use something like [this](https://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.datasource(v=vs.110).aspx), instead of what you did with the Row. And then continue whit [this article](http://csharp.net-informations.com/excel/csharp-excel-oledb.htm) from the link I already gave
Re: OLEDB "select, where, like" Query
Programming
Software Development
13 Years Ago
by Momerath
OleDB doesn't handle the SQL query at all, it just passes it to the database. So I don't understand why you think a where clause won't work, unless your database doesn't support them.
Re: excel validation
Programming
Web Development
11 Years Ago
by Cherothsulalea
Excel Sheet is more beneficial to doing work for creating a data and report.
Re: Excel Spreadsheet Issue
Hardware and Software
Microsoft Windows
13 Years Ago
by mjdodd
excel itself has a helpful programming system within it. you can reference the contents of any cell (or other page with cells) by using the 'title' of the cell (or page and cells) (or even worksheet, page, and cells!). So if you concoct a formula like in cell A1 = (page jan(ci))cell B1 = (page jan(c2)... etc and then use fill down it will …
Re: How to get Date formate while importing excel
Programming
Web Development
8 Years Ago
by David_50
Excel stores dates as floating point *days* since their epoch *1900* (not the unix *1970* epoch in *seconds*). Some adjustment is required, both in scale and in offset. You don't need a date diff tool, just the right constants for multiply (86400 sec/day) and subtract (days, 1900 to 1970 = 2208988800/86400).
Re: Does anyone know how to make a data entry worksheet in excel 2007?
Programming
Software Development
10 Years Ago
by jwenting
Excel IS a data entry worksheet :)
Re: EXCEL Formula Help
Hardware and Software
Microsoft Windows
14 Years Ago
by cole davidson
Excel does not have the features for what you are trying to do. You can however create two different purchase orders using two Excel sheets, one for each state.
Delete blank lines in excel cell using vbscript
Programming
Software Development
11 Years Ago
by bangla
Excel cell(1,2) has data with blank lines as: " vb is hard language. test data. test vb. " I want to change to without blank lines as " "vb is hard language. test data test vb" Below code is not working. Please please help. ---------- Set ExcelApp = createobject("Excel.Application") …
VBA Excel LookUP Function
Programming
Software Development
11 Years Ago
by nquadr
# Excel VBA Lookup Help # Hi I am having trouble with my VBA Lookup function. I have created 2 workbooks which I have instantiated to wbOld and wbNew. I am taking a column from wbOld and comparing with a range in wbNew. I want it to return the second column, with an exact match. Unfortunately, it is not working. I believe it to be a problem …
Time difference in excel
Hardware and Software
Microsoft Windows
1 Year Ago
by jithan.palakkal
Excel time difference error I am using a time difference =A1-B1 =A2-B2 =A3-B3 and it's value =23:50-23:40 =00:50-00:40 =02:40-02:30 But in the middle returns 0:00 And first and third return correct answer please suggest to correct the result
Re: searching excel colomns and sheets
Programming
Software Development
14 Years Ago
by darkocean
OleDb :) dear Sknake
Re: Generating an excel file.
Programming
Web Development
15 Years Ago
by buddylee17
Excel is basically tab delimited. Basically, in between columns add a "\t" to insert a tab to let excel know that the first column is finished and the second column should start. To start a new row, add a "\n" to force excel to put the next data in a separate row.
Re: Datatable to Excel
Programming
Software Development
11 Years Ago
by deepanbecse
"Excel.ApplicationClass excel = new Excel.ApplicationClass();" getting error in the above mentioned line.. "Microsoft.Office.Interop.Excel" has no constructors defined..this is the error message Can any one help me out..
Re: Import Excel data in MySQL Table after few manipulation
Programming
Web Development
10 Years Ago
by rch1231
Excel will save files as a .CSV (Comma Separated Values) and MySQL will import a .CSV easily. I would recommend that you first import your data files then update other tables using the tables you imported. Normally I drop the tables and re-create them prior to each import to prevent problems. You can either use a MySQL LOAD statement or the …
Re: Strange Excel infinite-loop problem
Hardware and Software
Microsoft Windows
16 Years Ago
by MidiMagic
Excel 2003 I have to reply because I can't edit, due to the upidstay time limit.
Re: How can I export the data which is in excel format?
Programming
Web Development
12 Years Ago
by rch1231
Excel will export to either a CSV (comma separated values) or tab delimited file. If you are trying to get data read by excel your best bet is to save it as tab delimited and with a .TXT extension. Excel will automatically import the file when opened with Excel. And yes images can be embedded in php but I am not sure about videos.
Re: Transferring data to Excel
Programming
Web Development
17 Years Ago
by tgreer
Excel is not a server application. Asking it to be a "chart server" for your web application is not going to lead to a scalable application. I would suggest either: 1) creating your own charts directly, which is possible using the Graphics namespace. Create images based on form data, and stream them right back to the user, or 2) get […
Re: Can't print some Excel files
Hardware and Software
Microsoft Windows
14 Years Ago
by carolsmith62
Excel worksheets can get corrupt or damaged at any point of time. Just imagine working on important financial figures and power goes off. And when power comes back, you cannot access your worksheet or the excel file fails to open. Now what to do?
Re: MS Excel Formula Prob
Hardware and Software
Microsoft Windows
15 Years Ago
by Suspishio
Excel 2007 has increased this limit from 30 to 255 items in your argument list. No way of doing it directly with your version of excel.
Re: Export PHP Result To Excel 2003
Programming
Web Development
14 Years Ago
by almostbob
excel file format is proprietary, excel can read/write .csv comma separated values php can read/write .csv comma separated values a bunch of tutorials on creating the button to do so [url]http://www.google.com/search?hl=en&q=php+export+mysql+table+as+.csv+tutorial&meta=[/url] have no idea how myself
Re: Export PHP Result To Excel 2003
Programming
Web Development
14 Years Ago
by chrishea
Excel can read HTML and open it as a spreadsheet. My Desktop Write utility takes advantage of this to create Excel, Word and other types of output. Get it here: [URL="http://innovationsdesign.net/wb_2.7/pages/tech-resources/downloads.php"]http://innovationsdesign.net/wb_2.7/pages/tech-resources/downloads.php[/URL]
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