Search DaniWeb - excel2010

Extract Tabular Data from PDF Images using Hugging Face Table Transformer 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 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? 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. 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: Reformat Data 10 Years Ago by Phenol Excel Re: excel validation 11 Years Ago by Cherothsulalea Excel Sheet is more beneficial to doing work for creating a data and report. Re: Excel Spreadsheet Issue 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 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? 10 Years Ago by jwenting Excel IS a data entry worksheet :) Re: EXCEL Formula Help 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 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 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 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: Generating an excel file. 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 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 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 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? 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 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 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 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 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 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] Re: macros in Excel for iMAC 18 Years Ago by yellow Excel -> Open file -> Tools pull-down -> Macro -> Macros... -> Any macros in the file should be listed. Select and press the Delete button if you want to delete them. Re: How would you turn an Excel spreadsheet into a protected software application 16 Years Ago by leo002000 Excel is a specific analysis package, and as such it performs very well in certain things ie analysis. To attempt to replicate its features in another application would be a waste of time. If you want to share/distribute it then just save it and move it. Re: Converting Excel Spreadsheets to HTML for Mac 14 Years Ago by MidiMagic Excel can save a spreadsheet as an html file, but the file is quite messy. Re: Reading an Excel File with C++ 13 Years Ago by jonsca Excel can generate plain text files in CSV (comma separated values) format. You can use tabs or spaces also (though you must choose one of the three I believe). There are libraries out there that can give you more bells and whistles but you might not need that. Re: help creating xml output from excel using xsd 12 Years Ago by tgreer Excel isn't XML. Re: HTML Form to Query Excel Data 12 Years Ago by Dandello Excel isn't a web application, so I assume you're actually referring to converting the spreadsheet to a database and then querying it? In that event, there are numerous possibilities, Perl, PHP with MySQL, anything with the capacity to query a database... The most common method for a web application would probably be a php form querying a MySQL … Re: sql data import 9 Years Ago by Begginnerdev Excel is formatting the number. Open excel and set the desired format for those columns. First select the column: ![2c3a3bd75a4df2f9283ee563f1501fb8](/attachments/small/2/2c3a3bd75a4df2f9283ee563f1501fb8.png "align-left") Next set the formatting: ![c536ebac45fe03bdcf1984565daa2667](/attachments/small/2/…