Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
excel_interop
- Page 1
Extract Tabular Data from PDF Images using Hugging Face Table Transformer
Programming
Computer Science
1 Month 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
1 Month 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)
Defining Ranges for Excel in VB.NET
Programming
Software Development
13 Years Ago
by Tweed
I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel *and* define the Range using numbers. Alright, so I have objects being created depending on the file that the user opens. So there could be 100 objects or there could be none. Now each object has an array of values, and these arrays…
Re: Excel Update to 2010 not working with Application
Programming
Software Development
11 Years Ago
by Oxiegen
I found some more information regarding the removal and re-adding of the reference method I posted. After you remove the reference from the project, you should also delete the auto-generated Excel interop assembly in the application's bin folder. Then re-add the reference to the project.
how to get value in Excel Spreadsheet using excel interop
Programming
Web Development
13 Years Ago
by kieky
can you help me to get value in excel spreadsheet using excel interop so that i can saving it into a 'variabel' or as text.. Thx a lot..
C# Excel Interop
Programming
Software Development
12 Years Ago
by ChaseRLewis
So I've programmed using Excel Interop before, but I can't figure out something. I have a spreadsheet with thousands of material properties listed in them. In the excel spreadsheet if I change that enum I can recalculate the sheet retrieving the values I need. I want to form a repository of info so I can retrieve it for another program I'm …
Re: Excel VBA - Check each column is empty until last column
Programming
Software Development
8 Years Ago
by overwraith
One of the things I have noticed about Excel programs is occasionally Excel thinks that comma separated value text(CSV) files are excel files, so it will automatically open them. You can alter these files with text operations however. Then there are completely different actual excel files which need operated on through excel interop. You are …
Re: Excel VBA - Check each column is empty until last column
Programming
Software Development
8 Years Ago
by overwraith
Stop refering to it as the same cell, you're confusing everybody! A 'cell' is one box. A 'row' is one line of boxes left to right. A 'column' is all the cells in a vertical line (up/down). So what you seem to want is to take the repeating rows, and put them all on one row, one after the other? These terms matter when you start dealing with the …
Re: reading a column from excel using c#
Programming
Software Development
11 Years Ago
by AleMonteiro
I get it, I don't know the cause for your error, but take a look at a piece of my code using excel interop, maybe it can help you: Excel.Worksheet sheet = (Excel.Worksheet) sheets.get_Item( i + 1 ); Excel.Range usedRange = sheet.UsedRange; Excel.Range columns = usedRange.Columns; for ( int c=0; c < columns.Count; c++…
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: Excel and C#
Programming
Software Development
15 Years Ago
by mcriscolo
If you mean that you want to manipulate an Excel workbook from a C# Windows app, then perhaps this [URL="http://dotnetperls.com/Content/Excel-Interop-Performance.aspx"]link[/URL] will help.
oledb to read Excel file
Programming
Software Development
13 Years Ago
by KatyHex
I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have to read the data which it can't seem to do. It accesses the file alright because I can't open the file while I am at a breakpoint. It attempts to read the file because oExcelReader.fieldcount = 14 which is correct. oExcelReader…
c# and Excel chart positioning
Programming
Software Development
15 Years Ago
by Sparky1208
Hi all, I hope this question is in the correct area of the site. If not, someone please advise. I am creating Excel pie charts using C# Excel Interop. My problem is that my charts (plot area, I suppose) are never in the horizontal center of the chart area. However, my chart titles do appear in the horizontal center of the chart area, …
Re: clearing excel file before upload
Programming
Software Development
11 Years Ago
by deceptikon
> the actual excel file... Okay, so within the Excel file are you trying to remove a single worksheet or does the file only consist of one worksheet? The ideal situation would be if you could just delete the file since that's the simplest. If you really need more control over the spreadsheet than insert, update, and select, you'll have to move …
Re: clearing excel file before upload
Programming
Software Development
11 Years Ago
by deceptikon
> I think he means that the Workbook contains many Worksheets and he needs to delete the first worksheet before uploading it to the database. That still doesn't make much sense. Just don't upload the first worksheet. > Unfortunately I don't know anything about using Excel in C# so beyond my interpretation I can't offer anything else ^^ He'…
Re: clearing excel file before upload
Programming
Software Development
11 Years Ago
by Ketsuekiame
> That still doesn't make much sense. Just don't upload the first worksheet. I didn't realise you could be that selective. In my mind I was using the concept of a workbook and uploading this container, rather than uploading the individual worksheets. > He's accessing Excel through an OleDB connection, so aside from a few sticking points …
Re: Microsoft.Office.Interop Word/Excel Manipulation
Programming
Software Development
15 Years Ago
by S.P.G
Very clever!! When I first saw the method GetTotalProcessID I thought huh? Then I saw the logic, very simple :) The client has say two instances of Excel running, so sum the ids The code starts another instance, so sum and subtract to get its id :) Then you can use that id to shut it down if really needed using System.Diagnostics I have …
Re: Microsoft.Office.Interop Word/Excel Manipulation
Programming
Software Development
14 Years Ago
by BarbaMariolino
Hi, using Interop is not best way to work with Excel in .NET. You can try using GemBox .NET Excel component which is free for commercial use (limit is 150 rows). [url]http://www.gemboxsoftware.com/GBSpreadsheet.htm[/url] Here is a list of reasons why GemBox.Spreadsheet is better then Excel Interop and Excel Automation [url]http://www.…
Office 2007 automation error on windows 2008
Programming
Web Development
14 Years Ago
by Bugaya
I have an enquiry concerning office 2007 automation on windows 2008 64bit. Basically the issue is as follows: · I'm using office 2007 automation on windows 2008 64bit, my solution is using excel office automation (Excel interop assemblies) from a .Net managed DLL to export reports in excel format from the server (windows 2008 64bit), · …
Re: Office 2007 automation error on windows 2008
Programming
Web Development
14 Years Ago
by vkale
I have same problem. Appriciate any help ASAP. [QUOTE=Bugaya;897304]I have an enquiry concerning office 2007 automation on windows 2008 64bit. Basically the issue is as follows: · I'm using office 2007 automation on windows 2008 64bit, my solution is using excel office automation (Excel interop assemblies) from a .Net managed DLL …
How to debug this code
Programming
Software Development
14 Years Ago
by si01
Hey I am trying to build this application, but I am having trouble as error messages keep appearing. Using Visual Studio 2008... [code] using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; using Opc; using OpcCom; using Opc.Da; using Opc.Hda; namespace ConsoleApplication3 { …
Microsoft Office Components
Programming
Web Development
13 Years Ago
by vvashishta
I'm using Office Outlook and Office Excel interop library in my code. When I debug the application it works exactly as required on my local machine and at server too(remember only when I debug) but when I host the web application on server it throws an error that [B][B]"Active X Component"[/B][/B]. I have added all dlls to the …
Can a backgroundworker be told to wait
Programming
Software Development
9 Years Ago
by PerplexedB
I'm using Excel interop and it seems that this functionality needs to run in the User Interface thread. So I execute that from the ProgressChanged backgroundworker event. Is there a way to have the dowork event (that invoked the progress changed event) interrupt execution until the ProgressChanged event is finished? Here's how the bg is …
Re: How can I remove empty columns in spreadsheet
Programming
Software Development
13 Years Ago
by nick.crane
Nowhere are you setting the values for the objects oXL and oWB. I suspect the null exception is due to this. You cannot manipulate an excel file without opening it. Your [I]removeEmptyCols[/I] method does not open any files nor does it even know which file it is working on. You should pass the [I]myfile[/I] string in to [I]…
Re: How can I remove empty columns in spreadsheet
Programming
Software Development
13 Years Ago
by nick.crane
In order to make changes to any file (Excel or otherwise) you have to open the file. To edit an Excel file in C# you will need to start the Excel interop application and open each file in turn. If you organise your app correctly you should only need to start Excel interop once for all the files. If you use [I]ReleaseComObject[/I] to relese each …
Re: Program stopped working and I don't know why?
Programming
Software Development
14 Years Ago
by kevin.cochrane
Hi Sknake Sorry it's taken so long I've been caught up in other things. I think it is trying to cast System._ComObject. The Full error reads: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Worksheet'. This operation failed because the QueryInterface call on the COM component for the…
Re: xlsx file format or file extension is not valid
Programming
Software Development
10 Years Ago
by G_Waddell
Hi, Do you have Excel installed on the machine? and if so, is it a version later than 2003? i.e. 2007 onwards to handle xlsx files? Or could something have changed the file associations? Also you are opening the file by interop when you get the error not as a datasource. How are you referencing the Excel Application? By adding a reference to the …
Re: VB NET Process.start question
Programming
Software Development
12 Years Ago
by lolafuertes
Not from my knowledge. The proces start determines if the target is an executable. If not tryes to search for the default program associated with the extension and launches it like if you double click on the file. If you want to interact with Excel, you'll need to use the Excel interop object model. You can read [url]http://msdn.microsoft.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