excel

SSAS 2005, Excel 2007, Ragged Hierarchy

I am trying to update a SSAS 2005 cube adding a ragged hierarchy (it has a few levels that contain members that should be hidden if the member name is the same as the parent). From various sources I have read that I need to use MDX Comparability=2 within the connection string to see the HideMemberIf property. I have read so many opinion...

How to stop a Macro either if it has been run already or if a there is a value in a particular cell

I'm using Auto_Open on a Excel Template (.xlt) to run a macro which imports some data to a sperate sheet, adds some forula and then creates a number of pivot tables and charts. The result of which is a finalised report which can then be saved as .xls. I have added the following IF statement to the top of the Auto_Open sub to check cell...

Creating and Editing Excel Documents (.csv) with Java

Hello everyone! For this project I'm working on, I want to take multiple excel sheets and then merge them into one, manipulating the data as I please to make everything a little more readable. What would be the best way to open files, read their contents, store that content, create a new file (.csv), then paste the information in the o...

compare excel and access to update data

Hi All, I am using Remou trick shown here... to compare excel data with access table to update changes. Is there a way to have excel to update any new data found using the same batch technique. Also can I incorporate it in the below mentioned code in any way. Sub UpdateMDB() Dim cn As Object Dim rs As Object strFile = Workbooks(1).F...

Dynamic Shift Rota Advise

I am stuff on a problem regarding setting up a dynamic shift rota at work. What it has to do is there are 3 people per team and 3 jobs to do (which they do as equals as it can be per week) and when someone is off lets call it job 3 is just not done that day. I have been able to make it to set true or false if there in but having troubl...

excel formula to strip html

I want to strip all the html away from the left and right of the textual value: I have this... <option value="41">GECommonUI</option> I want to get this... GECommonUI ...

vba collection maximum size

here's my code: Sub isdofsodjisf48023jroi23f984444444jiodfiosj12348023jroi23f98() Dim colFiles As New Collection RecursiveDir colFiles, "C:\Documents and Settings\Alex Gordon\Desktop\testing\files\", "*.xls", True Dim vFile As Variant For Each vFile In colFiles Call writeincells(vFile) Next vFile End Sub P...

Finding starting row number of a range name of Excel

Hi, In an Excel worksheet, I have a range name "LOOPBACK_IP". I want to programmatically find the starting row of this range name. With Powershell, if I want to find the value of this range, I use (after assigning $ws variable a worksheet): write-host $ws.Range("LOOPBACK_IP").Value2 But to find the location (i.e. row, column) of a r...

SQL server reporting: subreport doesnt handle page breaks properly when exported to excel

I am running into a problem where I have a main report which calls sub report; the sub report contains data in matrix control. I am trying to export each week's data on a separate sheet on Excel, but excel only displays 1 week's data instead of 4 weeks. The same sub report, when exported to PDF, shows data weekly on separate pages, but i...

Rows written by PHPExcel cannot be read from other libraries

I know this isn't the right place to ask about this specific vague problem, but maybe someone knows this library well enough to enlighten me. Here is the thing: I am writting an Excel5 over an existing Excel file with PHPExcel. I need to upload that Excel to the Zoom website, so it can provide me with a list of tracking numbers. However...

working with HUGE spreadsheet

i have about 300,000 records in this spreadsheet. and there are a couple hundred columns!! one of the columns is the social security number and i need to replace it with some random identifier. i cant really do a vlookup because that is too taxing so i think i am going to write a macro can anyone please suggest to me how do i do this? ...

How to use the Print queue to avoid dropping pages

OK, I'm printing some stuff for work from C# using COM Interop with Office 2007 and BullZip PDF 7.1.1007. The issue I'm having is that if I don't tell the program to sleep for 2500 milliseconds, then the PDF printer drops pages. Which is weird. I'm wondering if anyone else has experienced this issue. I will post the code if that hel...

Plotting in F# using Excel

Having been able to add data to an Excel spreadsheet from F# using the answer at http://stackoverflow.com/questions/1214130/f-and-excel-integration-for-net-4-0-visual-studio-2010-beta-1 I find myself unable to figure out how to use the data inserted to create a chart (programmatically in Excel using F#). How can this be done? I am usi...

Need Help Inserting Double or Single Quotes

Hi everyone, I have a long list of names that I need to have quotes around (it can be double or single quotes) and I have about 8,000 of them. I have them in Excel without any quotes and I can copy all of the names and paste them no problem but there are still no quotes. I have looked and looked for an Excel formula to add quotes to the ...

Save Excel sheet into SQL

Excel has a Get External Data ribbon bar in the Data tab where we can choose to import tables from SQL databases. This process worked out nicely for me. But my question is, is there any way to save this data back into SQL? Does Excel provide some API that facilitates the coding of such a function without parsing everything and doing it f...

Data Scraping from PDF and Excel

I am doing a little data scraping, There are 3 types of file from which i am scraping data. 1- HTML 2- PDF 3- Excel(xls) For HTML i am comfortable, i am using HTML Agility for that. For PDF and excel i need suggestions from anyone. Thanks in advance. ...

How to read Excel cell having Date with Apache POI???

I'm using Apache POI 3.6, I want to read an excel file having date like "8/23/1991". switch (cell.getCellType()) { ... ... case HSSFCell.CELL_TYPE_NUMERIC: value = "NUMERIC value=" + cell.getNumericCellValue(); break; ... } But it takes the numeric value type and returns the value like this "33473.0". I've...

Excel pivot table using date column to filter results

I have a Pivot Table which I have entered a date field into the Page Fields area to filter the data in the page. However, I only have the option to select individual dates. I want to use a date range. How can I do this? Or Can I do this? ...

PHP Excel Output for IE gives empty file.

Hi all, I am trying to generate an excel file with php. This works fine in Firefox but with IE I am only getting an empty file. This is what I am doing basically: header('Content-type: application/ms-excel'); header('Content-Disposition: inline; attachment; filename='.$filename); echo $data; I have tried various header settings but ...

Excel Interop - Alter HTML imagedata Source From Client Side

Hi, any help on this matter would be greatly appreciated. I've create a report from excel using PublishObjects.Add using Excel Interop, and i output the data without any problems. My question is - Is it possible to access the v:imagedata tag from the client side using javascript or jquery? While the image is loading i would like to put...