Hi All, I have Excel file with cells content like 6h 18 m I.e. this cells contain duration values. I need to add new column to this spreadsheet where I will use values from exisitng ones in minutes. For example: cell A1 = 6h 18 m I want to add new cell with formula like = convertToMinutes(A1) + 5 Can anybody halp me? ...
I'm trying to learn Apache POI for Java quickly (for manipulating Excel). I've been googling for tutorials, but so far all I've found is short, 2-paragraph explanations followed by a code sample. I wanted to find something a bit more comprehensive, that is concise but walks through it in a structured, complete, and understandable way. An...
I have an excel sheet with values in columns A, B and C like this: A B C 1 8.22 1.99902 32.48974 2 8.22 3.04698 33.92426 3 8.22 2.26374 33.1547 4 8.22 2.78227 33.2593 6 8.22 2.46798 33.34269 6 8.22 2.57802 33.67131 7 8.22 2.46798 32.7427 8 8.22 2.57802 33.07131 There is also a ce...
I have a system of 22 linear equations (exactly 22 equations and 22 unknowns) which are dynamically generated in an Excel spreadsheet. Is there a way to have Excel solve the system and produce a value for each of the unknown variables? Another SO question has a lot of good information about the algorithms used to solve such equations. C...
I know there are a lot of questions on how to write data from a dataset or datatable to excel, but they all seem to assume a new blank excel workbook. I have a special excel file containing multiple sheets with lots of formatting, formulas, and a chart. I just need to lay data over the appropriate portions of some sheets and let excel ha...
I have a .NET C# windows app that I need to read some excel data into. I have started by writing some unit tests .. one of the first just trys to instantiate a Workbook, and it is throwing this error ... System.Runtime.InteropServices.COMException: System.Runtime.InteropService.COMException: Retrieving the COM class factory for compone...
I run a sports program where i have a master roll of who is in which class in excel. I want to link this to a database in access that stores the other information about each athlete, e.g. address, parents name, school, medical details. I want to be able to add names to class in the excel speadsheet and have this automatically generate a ...
I got stuck in the problem beneath, because I don´t use Access or Excel much and I have some basic programming language. So here's the deal: I just made a fairly simple database in MS Access (2007) with a nice query to retrieve data, depending on which parameters you pass. In Excel (2007), I have this big 'template' which basically has...
Hi, Is there a function to get the address of a cell which call a VBA function ? I used "Application.ActiveCell.Address" , but found that this method is not a correct way to get the address of calling cell. e.g: If we have excel sheet with saved VBA functions, Once you reopen the sheet, the above method will not work. please help n...
Hi Folks, we have a bunch of reports (RDL) on SSRS built using officewriter. Sometimes errors occur in a report after updating the excel template. While the report renders fine, an error occurs on the server when trying to save the report using 'export to excel format for office writer' option. How do we debug to find the cause of the er...
Hi, Is there any module for creating Excel charts with embedded charts in Python? The modules mentioned in this question don't seem to have that capability. I prefer a generic module that would work under Ubuntu, not a Windows-dependent one. EDIT: I will also appreciate ways to embed images within the created charts, as I can create t...
I have list of STD Codes. If I paste a STD Code as 04562 , it automatically truncates the leading zero and store it as 4562. But I want it to to store it as 04562 Plz Give me a solution. Any Help will be highly appreciated ...
I'm trying to create a linked OLE Object in a Word document using VB.Net. Existing code uses InlineShapes.AddOLEObject(FileName:="abc.xlsx", LinkToFile:=True, Range:=Some Word Range) to insert a worksheet into a Word document. I need more control than this. To select a range of cells I've found that extra information after the filename...
Hello:) Did anybody export tables from HTML Document to Excel with saving all css styles? My app can generate html code for table but i need to export зrecisely same table to Excel. I use OpenXML. May be it is necessary to use urn:schemas-microsoft-com:office:excel and urn:schemas-microsoft-com:office:spreadsheet namespaces? Thanks all...
Hello All, I seem to have a dilemma. I have an EXCEL 2003 template which users should use to fill in tabular information. I have validations on various cells and each row undergoes a rather complex VBA validation upon change and selection_change events. The sheet is protected to disallow formatting activities, insert and delete of rows ...
I need a macro to look at the list of data below, provide a number of instances it appears and sum the value of each of them. I know a pivot table or series of forumlas could work but i'm doing this for a coworker and it has to be a 'one click here' kinda deal. The data is as follows. A B Smith 200.00 Dean 100.00 Smith 1...
Right, I have a photoshop PSD file, a spreadsheet filled with custom data and a folder full of images. I want a way to create a unique image for each entry in the spreadsheet, where the spread sheet contains data that must populate text elements in the PSD, and references an image which needs to be pasted in to photoshop. I would normal...
I'm looking to download data tables from websites into Excel and pull specific pieces of data into a separate worksheet to create a database. I'm having trouble parsing numbers that are imported into one cell in Excel. For example, the numbers "-7 -110" written exactly like that on the website are inputted into one cell in Excel as "=-...
Hi, I have the excel sheet , I want to keep it as datasource to the gridview . gridview will be editable so whatever the data updated sholud be write to again in excel sheet with respected location in sheet. How can i do this ? Please help me . ...
Hi, I have working on a piece where I give option to user for uploading and later download .xls(MS 2003) and .xlsx(MS 2007) files. No issues I find while uploading, but while downloading the content, I get below mentioned dialog box while opening the downloaded .xlsx. Excel found unreachable content.Do you want to recover the cont...