excel

Linking cells in same Excel spreadsheet

In Excel, how can I set up a spreadsheet so when I type in one cell it will populate another cell in the same spreadsheet? ...

Writing to a blank excel sheet with ADO.NET

I am trying to use ADO.NET to connect to and write to an excel file. I have created a blank file with the default excel sheets (I have also tried with a custom sheet.) For some reason I am unable to write a full row of data to the sheet. If I create a new sheet it works fine, however then I have too many sheets and I am unable to delete...

Convert a lot of excel files

How can i convert a lot of '97 excel file to '95. I look for other solution as File - Save As. ...

Need help creating a conditional copy macro for Excel 2003

I would like to conditionally copy data from multiple worksheets into a single worksheet in a given workbook in order to consolidate data. The macro would look at column F in all the worksheets, and if a row in column F matches a given number, that row gets copeid. Any help would be great!! Terry ...

How can access formulas as I process it with Matlab?

I load an xls file in Matlab, and I need not only the numeric values but the formulas also. Do you have any idea? ...

c# export excel maintain fraction value

I'm exporting (by that I mean using the contentType) an aspx page to excel. It works fine, except for when the value is like 1/6. Instead of excel displaying 1/6. It's displaying 6-Jan. Is there something in c# that I can put around the value being exported that says, keep this value a fraction when it is a fraction? Thanks. ...

Disconnecting from excel 2007 data source

Hi! I have and excel file which is connected to an external xml file and uses it as data source (every time I use "refresh all" it reads the xml file and updates the sheet with the data). I want to disconnect from the data source (so that the current data will be copied to the sheet, and pressing "refresh all" will do nothing). I trie...

How to easily insert Excel spreadsheet into web page?

Hi, I would like to insert an Excel spreadsheet into a Web page but would like to change some of the data at the same time to make them more user friendly. Is it easily possible? Thank you for your help. ...

VBA code:: seperate column into two parts but in each part still got ascending date

Hello, bascially, i have got a column consist of data that i want those starts with "EMUA-I" to be place at the front, with the ascending order of date. Then i want the "non EMUA-I" part to be placed at the back with the ascending order of date. please take a look at this reference file : http://www.speedyshare.com/files/23397356/1....

Importing large amounts of flat XML files to excel

Hi, I have a bunch of XML files that have a flat hierarchy, but each contain a differing amount of (uniquely named) nodes. Example: <?xml version="1.0" encoding="UTF-8"?> <SomeName> <Node1> DataA </Node1> <Node2> DataB </Node2> <Node3> DataC </Node3> <AnotherNode1> DataD </AnotherNode1> ...

DataGrid & Excel selection

Hi guys, How can I implement selection logic for DataGrid like in Excel. Sample http://www.viblend.com/silverlight/controls/examples/livedemo.html ...

Integration of VB6 inside ActiveX and Excel

My company has an ActiveX application used by more than 50000 customers paying customers. The data people need to input into the ActiveX application is coming from Excel (actually csv or XLS files, which they open in Excel). What we would like to do is to create functionality where the customer can input "=" in a textbox in the ActiveX c...

Integrating with 500+ applications

Our customers use 500+ applications and we would like to integrate these applications with our. What is the best way to do that? These applications are time registration applications and common for most of them is that they can export to csv or similar, some of them are actually home-brewed excel sheets where time is registered. The bes...

Excel colours getting distorted when being copied from one template to another using VSTO(C#)

Hi, We are trying to generate an excel sheet using a template. Normally we would have done have a basic "Save As" to save the file but the file size came up to be too high. So, now we're working on copying the used range of the original workbook to a new workbook. The data is getting copied, along with the validations and formulae on u...

PHP and Excel rounding off

I have an excel sheet that has number in cell that are formatted as #,##0.00.. Now, when I try to calculate those values using php round() function as round($number,2) , sometimes, the values are not exactly same, difference comes in the 2nd decimal place. What can be the problem? Has anyone experienced the same? ...

How to detect installed version of MS-Office?

Does anyone know what would be the best way to detect which version of Office is installed? Plus, if there are multiple versions of Office installed, I'd like to know what versions they are. A bonus would be if I can detect the specific version(s) of Excel that is(/are) installed. ...

Excel Add-In deployment problem

I built an Excel add-in with VSTO 2005 SE, which I deployed to a user base that is predominantly Office 2003-based, but also with several workstations that have Office 2007 installed on them. On the Office 2003-based workstations, the add-in works perfectly. Now because this add-in was created with the version of VSTO for Office 2003...

Bit array AND in Excel?

I have a grid something like this: A A A A A B C C C C C B C C C C C B C C C C C B C C C C C B C C C C C Each A and B are numeric values derived from creating a bit array from some other work going on elsewhere in the worksheets. In C, I need to perform a bitwise AND on the intersecting A and B and test if the result is greater tha...

Is there an elegant way to Generate Excel spreadsheet from List<POJO>? (JAVA)

In java, Is there a elegant way to Generate Excel spreadsheet from List? ...

How to save and read user information (username ,password,and so on) to a excel ?

Note: each information is a String ! ...