Search DaniWeb - excel2007

Hi everyone, I'm clarawilliams 2 Days 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 2 Days Ago by pritaeas Welcome. Extract Tabular Data from PDF Images using Hugging Face Table Transformer 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: Get error please help me the server threw an exception. 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: Design vs. Coding 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? 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 … excel 8 Years Ago by adobe71 How to unprotect excel sheet without knowing the password. Re: excel validation 11 Years Ago by Cherothsulalea Excel Sheet is more beneficial to doing work for creating a data and report. Re: Excel range to string array 9 Years Ago by Suzie999 Thank you far taking the time to look ddanbe, I really appreciate it. But I have done most of the coding, my only issue is string array, here is my class. Please excuse my shabby coding, I'm still new to OOP. class oExcel : Form1 { public Excel.Application oXL; public Excel.Workbook oWB; public … excel in C# 13 Years Ago by judithSampathwa Hi, I have a question relating to excel sheets in C#. I have a button in a datagridview in C#, how can I open an excel sheet when I click on the button. And then when the excel sheet opens I need to edit it, so how can I open a excel file from C#. Thanks Appreciate a lot Re: EXCEL VBA (Combo Box) 10 Years Ago by ss125 USe datatable to store the excel data and use the following connection string for excel file try these: string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName); string fileExtension = Path.GetExtension(FileUpload1.PostedFile.FileName); string fileLocation = … excel error object reference not set to an instance of an object when start 7 Years Ago by Etienne_1 Good day I am experiencing issues with Microsoft Excel 2013 32- bit running on Windows 7 Ultimate 64-bit. Whenever I start Excel or switch to it from another program the following error message pops up: "An unexpected error occured: Object reference not set to an instance of an object" To the best of my knowledge, this started after a … Re: Excel Import text file 10 Years Ago by OsaMasw Am using Excel to open the text file,No VB or any external programs @Stuugie No the Fixed width didn't suffice because all information became in one cell so i can't make data filter or any excel operation Re: Excel range to string array 9 Years Ago by yesi_1 I guess you need to get excel range to string finally, if right ,recommend u a [.NET API-Spire.xls](http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html),after downloading and add dll to project,using the following code. Workbook workbook=new Workbook(); workbook.LoadFromFile("test.xlsx"); … Re: Excel range to string array 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: Excel range to string array 9 Years Ago by ddanbe I perhaps posted the wrong link. I guess [this](http://csharp.net-informations.com/excel/csharp-read-excel.htm) is more what you want. Re: Excel range to string array 9 Years Ago by ddanbe I should forget about that object thing you have. This is the code I use to get a string out of an excel cell. // Get data as string out of an excel cell public string GetData(int row, int col) { string Val = string.Empty; if (worksheet.Cells[row, col].Value2 != null) {… Re: excel error object reference not set to an instance of an object when start 7 Years Ago by rproffitt Did you try disabling all add ins? https://www.google.com/#q=manage+excel+add+ins EXCEL VBA (Combo Box) 10 Years Ago by newbie26 Hi, Can someone help me. I need to create a VBA project in excel using combo box. For example, I have in column A, combo box of ITEMSA and in column B, combo box of ITEMSB. If I choose items from ITEMSA, just the corresponding items that will match will be displayed in combo box B. ITEMS A Paris New York London ITEMS B A B C D E F G if I… Excel Import text file 10 Years Ago by OsaMasw I really didn't know where to post something like this so sorry guys if this not the right section I have a text file looks like this ![2fa901c9913d09a179701ace860f9afa](/attachments/large/3/2fa901c9913d09a179701ace860f9afa.jpg "2fa901c9913d09a179701ace860f9afa") ![95c4115e80bcf8e3e28c3dc9842a1917](/attachments/large/3/… Re: Excel Import text file 10 Years Ago by Reverend Jim Are you trying to import the data from within Excel or are you doing it from another environment such as C, C++, vb.net, vbScript, etc.? Once we get more information we can move this thread to the appropriate forum and proceed from there. Re: Excel Import text file 10 Years Ago by Stuugie What do you mean > all information became in one cell If it's all in one cell then by all means the Fixed Width Text-to-Columns is the right course of action. I don't understand what filtering has to do with your original problem. One step at a time: >I want to import it into Excel file so each info will be in seperated coloumn You'… Re: Excel Import text file 10 Years Ago by OsaMasw Sorry guys , am not familiar with Excel so when you told me about Fixed width I didn't understand what you meant :( , but now I realize I can click on spaces to create "Fixed width" columns , sorry for this misunderstand thanks for the help guys. Excel documents locking up over Network 9 Years Ago by miniru We have a shared network drive with excel spread sheets on them, the connect between the two buildings is via a microwave, and every now and then the spread sheets will lock up. Can anyone suggest a budget sensitive solution that could improve the connection, and/or help with the freezes? Excel range to string array 9 Years Ago by Suzie999 I'm getting an excel range to an array. From my search it was clear I need to use object array. object[,] saRet; oRng = oSheet.UsedRange; saRet = (System.Object[,])oRng.get_Value(Type.Missing); This works fine, but what I really need is for that array to be string. So how might I cast object[,] to string[,]? I read it's a bad idea … Re: Excel range to string array 9 Years Ago by Suzie999 I found [this article](https://social.msdn.microsoft.com/Forums/en-US/9cee97a2-25d1-4d6a-b256-7667851e2170/convertall-and-2dimensional-arrays?forum=csharplanguage), which basically says 2 for loops is the only way, as Array.ConvertAll does only 1d array and uses for loops anyway. So I guess I'm looking for confirmation about the dangers of using … Excel Macro in VBA to go down rows 8 Years Ago by tommyneedshelp Hi I have an excel macro question in VBA. I have this code. I want it to go down each cell in row C and run the same if statement instead of just depending on cell C2. I want it to continue to C3, C4, C5, all the way till the end of the sheet. Can anyone help me solve this? Sub Macro1() Dim lngLastRow As Long … Re: Excel Macro in VBA to go down rows 8 Years Ago by Rene vK To have you on the path to a solution: Make a Do While loop with your found last row! use a Counter as variable for creating your range in "Cn" and match where you are. something like: Dim MyRowCounter as Integer = 2 Do While MyRowCounter =< LngLastRow concatenate your Range do your If MyRowCounter = MyRowCounter + 1 loop btw. … excel warning c# 13 Years Ago by arjunpk hi the code which i use to export a data table to excel works fine..... but when i open the excel file it gives me the following warning THE FILE YOU ARE TRYING TO OPEN IS IN A DIFFERENT FORMAT THAN SPECIFIED BY THE EXTENSION. VERIFY THAT THE FILE IS NOT CORRUPTED AND THAT IT IS FROM A TRUSTED SOURCE. the file opens anyway and has all the … Re: excel warning c# 12 Years Ago by C#Jaap a bit out of time, but for future searches: You use [CODE] Excel.XlFileFormat.xlXMLSpreadsheet [/CODE] which is actually an XML file. When you use the extension of an Excel workbook does not expect an XML file, so the message is shown. Excel won't show that message when you use: [CODE] //extension depends on the version of your excel …