excel

Possible to determine if an Word doc or Excel spreadsheet has a macro included?

When reading the binary of a Word or Excel doc into memory, is it possible to inspect the data to determine if a macro is built-in to it? ...

Can you create applications in Excel?

My friend said he was going to create an application inside of Excel. I told him that maybe he meant macros but he seemed convinced he could create a typical CRUD application INSIDE of Excel. Is this true? ...

Count Unique Rows in an Excel Spreadsheet that Meet Certain Criteria

I want to count all the unique values in an Excel column that contain a certain string. For instance, say I have this in my column: strA strB strA strC diffA diffB strC If I give this theoretical function that I'm writing a value of "str," it will count the unique values containing "str", and give me back the number 3. Any suggestio...

Access - Excel Integration

Hey all, have been working on designing a new database for work. They have been using Excel for their daily reports and all the data is stored in there, so I decided to have the back-end of the database in Access and the front-end in Excel, so any analytical work can be easily performed once all the data has been imported into Excel. No...

Jquery AutoSuggestion from Excel File

Hey All, I was just wondering if anybody knows how to make one of those autosuggestion textboxes so that when you begin typing, it will autosuggest based off of an excel file? I've searched everywhere and couldn't find anything, and I don't know where to begin. Creating the autosuggestion is not my issue, it's just getting the data fro...

delphi excel Hyperlink in a cell

How can I extract a hyperlink from some cell in excel table using Delphi? ...

How do I change the Excel logo that appears at the top left hand corner of my Excel session?

In Excel VBA I can use application.Caption = "mytitle" to change the title of the Excel session. I want to be able to go one step further and actually change the Excel icon to an icon of my own choosing. Can this be done? Please help. ...

Converting a serial number into date

Hallo friends, In an Excel sheet I will receive the data, which in turn I need to upload it to sql server and then implement the logic. I have received a date field --[Due Date] as number ex:-.40317. In Excel if you right click it and then format it to a date. It will show the correct date as 19.05.2010. So after uploading the file a...

How to sum non consecutive cells in jxls template

I am creating a xls report from template that uses data obtained from the Oracle database. I have a group and a subgroup. In a subgroup I create a table that displays the PREMIUM values and then the total using: $[SUM(I18)] Because values here are consecutive this formula is converted to i.e. SUM(I18:I35). After all subgroups are dis...

How can I solve a system of linear equations in Excel

Hi, I am having some trouble finding a solution for a system of equations using excel. The system is of the form Ax=b, with A a matrix and x and b vectors. Obviously, the goal is to find x. The system does not necessarily have the same number of equations and unknowns. An exact solution is not always possible. Therefor I want to find t...

Error in using getRichStringCellValue() of Apache POI

The following is my java code for reading a excel sheet content. String urlcnt=""; for (Row row : sheet) { { Cell firstCell = row.getCell(0); urlcnt=firstCell.getRichStringCellValue();} While compiling the above code am getting the following error. ReadExcel.java:18: incompatible types found : org.apache.poi.ss.usermodel.RichTextS...

Passing command line arguments to Excel causes workbook to attempt to re-open. Can you help fix this?

We have a C# app that launches (mainly) Excel based programs, passing user information etcetera via the command line, e.g: "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "C:\Program Files\Some Folder\ExcelApp.xlsm" A/SimonCowen88/MyPaSsWoRd/OtherInfo/... On some users' machines this method causes ExcelApp.xlsm to 'open...

Invalid header signature; IOException with Apache POI on excel document

Hi, I'm getting: java.io.IOException: Invalid header signature; read 0x000201060000FFFE, expected 0xE11AB1A1E011CFD0 when trying to add some custom properties to an excel document using apache POI HPSF. I'm completely sure the file is excel OLE2 (not HTML, XML or something else that excel doesn't complain about). This is a relevant ...

Is there a pre-existing sulution using c# with the Excel Interops to template excel like jXLS does?

I'm looking for comments, alternative solutions and recommendations. Background: We currently have a CRUD app built on Websphere using the struts framework. We generate excel documents using a standalone C# application that is tied together to the web application using an ActiveX control. We pass XML that contains elements for each docu...

Dynamic JNLP Generation and invocation from Excel

I have an application which is invoked via Java Webstart. Opening it via the Webstart link works without any issue. I also have an application based on Excel that generates files (via vba) which can then be opened by the program that starts via Webstart. What I would like to do is have a button that invokes the Webstart application and...

Excel Performs Two Requests on Hyperlink Click

Hi, I used the HYPERLINK method to display a hyperlink in a cell. I have Fiddler running and I have noticed that two requests are sent to the same url for each click on the link. Has anyone else experienced this? Have you found a way to only send a single request? (I have tried using the AutoCorrect feature to display a hyperlink,...

Passing Null Values to Web Services Via SOAP Using Excel VBA

I have a Web Service which has one WebMethod with nullable parameters: [WebMethod] public void SaveValue(double? Real, double? Meta){ //Do the magic... } In my Excel I'm calling the WebMethod as below: Dim WebSvc As MSSOAPLib.SoapClient Set WebSvc = New SoapClient Call WebSvc.mssoapinit("http://localhost:10618/WebService.asmx?wsdl"...

Choosing Parameter In Excel

I have a datasource that poplulates my sheet from sql server. There is a parameter to refresh the data. Can I have the choices come from a drop down menu on another sheet? ...

How can I convert MS Excel 2.x files into CSV format?

I currently have MS Excel 2.x (BIFF2) files that I receive from a client. They need to be loaded into an ETL system via SSIS. From what I can tell and from my tests, SSIS cannot read these files directly. I have also tried using Aspose.Cells for .NET to open / convert these files in .NET with no luck. Hopefully there is another way t...

I want to sum every 7 rows in a worksheet and put the sum in different column & rows

I have never really used Excel before but this seems like it should be possible. I have an ongoing document where I will be adding values every day, but what I want it to do for every 7 rows I want it to sum those values and add the sum of the 7 rows to a different column/row, e.g., Row B7:B14 Sum in D12 Row B15:B22 Sum in D13 And th...