The excel solver works for some functions but does not work for other simple functions. For example, f(x) = SQRT(A1^3-1), excel solver does not find roots. But other similar function works for example f(x) = A3^3-SQRT(A3)-1. Do you see any problem with the first function? Is it supposed to be expressed differently? ...
Hi, I need to display the newly generated excel (from tables using Apache POI) in a web browser (whatever it is, Firefox, Opera or IE). I've created the JSP file with contentType="application/vnd.ms-excel" But I'm not getting it. Here's my code snippet : <%@page session="true" contentType="application/vnd.ms-excel" pageEncodin...
I have an array formula in Excel that returns unsorted values. I want to put the sorted values somewhere else on the sheet and for these values to update and re-sort themselve whenever the source values in the array cells change. I have no idea how to do this! I suspect it could be done with a macro but I'd rather not do that if I can a...
I'm trying to read in an Excel spreadsheet with C#/ASP.net. This entry here works great if the workbook is on my local drive. However, when I attempt to access any workbook on a network share, I only get the first 30 rows of data. When I used File.Copy to copy the file to the local drive of the server, I only get 35kb (and the resultin...
=vlookup(c2,code1,2,false) I am using the vlookup code but I would like to use the cell value in 'c2' rather than c2 itself. The value within this cell will change, at the moment it is 'aj2'. Is there an easy way of doing this? Hi Thanks, that doesn't seem to work for what I want. I suppose it might be easier if I explain what I want ...
Problem: I have data that looks like this and I want to compare the rows to the column values. so is(Table1.t1 = Table2.t1)? kind of thing. Table 1 A B x t1 x t2 x t3 x t4 Table 2 A B C D E x t1 t2 t3 t4 Can I do this in Excel with functions or VBA ...
I have an excel spreadsheet that contains some formulas to calculate ROI for an upcoming product of a client. Is it possible to convert this into a php script whereby a user would type into some boxes and then submit it working out the same. The excel spreadsheet is here: http://www.solidcamxpress.co.uk/roi.xls ...
I've searched in google but I don't seem to find a way to read Excel files from Objective-C. The only answers I find are to first convert to CSV and then read as a text file, but I don't want that. I know there must be a way, while I used many times the PHP modules to read/write Excel files, so I'm supposing there's also a C library to ...
I am using this macro: http://support.microsoft.com/kb/119826 to try and clean up hidden names in my excel file. It works for most of the hidden names, but not for a few _123Graph names. I'm not sure where these names came from, but when I try to delete them I get a 1004 automation error. The knowledge base mentions that names with sp...
i have a simple mysql database. it has 3 tables. here is the create statement for them: CREATE DATABASE `qcvalues` /*!40100 DEFAULT CHARACTER SET latin1 */ CREATE TABLE `batchinfo` ( `rowid` int(11) NOT NULL AUTO_INCREMENT, `datapath` mediumtext, `analysistime` varchar(50) DEFAULT NULL, `reporttime` varchar(50) DEFAULT NULL, ...
I am reading this (Excel Tasks) to automate some Excel operations in VS2008 C# http://msdn.microsoft.com/en-us/library/syyd7czh%28v=VS.80%29.aspx But I couldn't find how to delete a column (or multiple columns). eg. How to delete column C and shift the rest left? Thanks in advance. ...
I'm trying to convert this delimited PDF to an excel (or some other delimited format). Using Adobe Acrobat 9, I attempt to save it and copy it) as Excel but it gives the error message "BAD PDF; error in processing fonts. [348]". I'm open to any solution that will create a delimited file, ranging from using Adobe Acrobat, to programmin...
hello! This task is driving me mad... please help! Instead of manually type in the data, i have used VBA to find the year range, put into one column and delete all duplicate ones. But since excel could give more than 20 years, it would be tedious to do all the filtering manually. AND, now i need excel to separate the rows that contain th...
Hi, I wrote a Java method that uses POI HSSF API to convert an Excel file to my data structure. The code worked just fine for a while. But now there are suddenly problems. I suspect it might be because recently we installed Office 2007 on all the client computers (previously we had Office 2003). The problem I run into is this: inside t...
I'm trying to upload Excel (2003) file into Sql server 2005. At present we are using SSIS to upload the file into a Temporary table (with defined schema) and then moving the data to their intended location using Stored procedure. This gives lots of errors due to datatype mismatch and sometimes null values are uploaded into table even t...
Hi, I have a column in Excel with names followed by numbers. I need to remove the numbers from all the names, how do I do that? My column and rows B2:B6718 follow this pattern: Name (6digit_number) I need to remove the (number) and the brackets surrounding the number. Administration af fast ejendom på kontraktbasis (683210) Administra...
I am trying to write some VBA code in Excel 2010 that would consume a web service. I am unable to find any related resources on the internet. Can someone please tell me how to do this. ...
I have a program that filters data and then outputs it to a tabg delimited file. I then use Excel Interop to open this file in Excel because directly outputting to a worksheet takes too long. So currently I am using this code: AD.DF.WriteToFile(vbTab) Dim WB As Workbook = ExcelApp.Workbooks.Open(AD.DF.DatafileInfo.WriteToFileLoc...
Hi all Need help with a Calculated column issue in SharePoint 2007 Basically, I'm trying to take the value from the [Contact E-Mail Address] column and remove the mailto: part infront which Sharepoint automatically created. Original Column Value : mailto:[email protected] Calculated column required value: [email protected] This is what i've go...
I am trying to filter for multiple criteria, but I see that the "Filter" option only has 2 fields for "AND/OR" options. I have a column full of links. I want to extract all rows that contain these in it: .pdf .doc .docx .xls .xlsx .rtf .txt .csv .pps Is there a good way to do this? ...