I'm trying to do what I thought was a relatively simple calculation between 2 tables I have in the new PowerPivot add-on for Excel 2010. My 2 tables loaded at setup as follows: Table 1: FooID, BarID, Name Table 2: BarID, Date There is a 1 to many relationship between Table 1 and 2. I want to add a calculated column to Table 1 that j...
Hi, I'm having a performance issue in my Excel macro. One particular piece of code runs really slow. I think the reason is the Offset function. I've found online that it is a volatile function which recalculates a lot. The strange thing is that I use it as a VBA-function, so I can't figure out how it would affect performance as it never...
Loading an XLS file is a bit of a pain for a quick app we're throwing together (we know about how to do that but it's not worth the time especially in C++) so we're going to take the simple approach of have the user export a CSV copy. However to save them the trouble I wondered if we can have a macro which will automatically save a CSV v...
So today a received an excel spreadsheet with over 20,000 cells onto it. I had to separate them by name (ever 14 rows starts a new client), and total the columns of prices. So, I wrote: Sub NewSpace() ' ' NewSpace Macro ' ' Keyboard Shortcut: Ctrl+p ' 'create the count variable, initilize it to 17 Dim count As Integer ...
Hi; After using WebResponse to export excel then clicking a Link gives Page expired error. Any suggestions ? Thanks. ...
I'm going to be generating some graphs from a lot of data located in multiple workbooks. The data is formatted exactly the same in all workbooks and reside in folders all at the same level. I'm going to be bringing parts (ranges) of the data into one final workbook where I'll generate my graphs from. This made me think that this sort of...
hello all I just want to ask .... is there any method or tool by which csv/excel file of products can be directly imported to magento database? I have no idea about it .. Thanks! Richa ...
I am new to VBA and i am struggling trying to make this work. I am in need of a macro that will process each cell\Column on Sheet1 and Put the Results on Sheet2. I'm sure this is pretty easy for those who are more advanced with VB code. It contains many columns.. Anytime we encounter a "—" or an empty cell we populate the cell with -999...
I have been using Apache POI for quite sometime and it works great but I am not able to find a reliable answer about filter support in the library. For reference, I mean the filter option available in data tab in excel which allows you to show all unique values of a column as a combo box in the header of the Column. I know there is alr...
i am doing a vlookup of some value is it possible to get the address of where that value was found? are there any other ways besides match and cell? i do thank you for your answers. but for some reason i am doing this: =cell("address",VLOOKUP(B2,Component!A:F,6,FALSE)) and this is not working i also tried: =address(match(b2,Compo...
is there a way to get address_of(vlookup(.....)) ?? where address_of = "A25" (or something in that format) ?? ...
I have a named range called "items" spanning 3 cols and 10 rows. In another worksheet I have a cell that uses a data validation list to allow a user to select from a drop down. In the source I want to specify the first column of the named "item" range. Is this possible? ...
Possible Duplicate: Importing excel data in mysql database Dear friends, I have about 5000 rows of excel data with 15 fields that must go in mysql database, what is a quick solution for this ? ...
I am trying to create excel order form which will have price and qty columns and customer will put the values in the qty column and excel will update order cost column. problem i am facing right now is that number of columns in excel file is changing i.e. user can select multiple columns. so price column location is different every time ...
Specifically what I am trying to do is add new worksheets alongside ones already there. I've tried to use book.create_worksheet :name => 'new_sheet' but it overwrites the previous worksheet. I searched the site here and saw some people using a different gem that allowed "book.add_worksheet" (the Spreadsheet gem is supposed to have suppo...
I have a VS 2010 Excel 2007 Workbook application. I have a ListObject that is bound to an object data source via a binding source. I want to be able to determine what property of my object any given ListColumn obect in my ListObject's ListColumns collection is bound to. In the example below I use the column name to find the column that i...
Good night. I'm having some troubles to get what i need done. I have some cells in a sheet that needs to be filled every day, manually. I have also a dropdown with all the months, and another one with the days. Is it possible to save data in specific cells for the selected dropdown values? Something like for each day mantain differe...
When a picture is inserted into an Excel worksheet using Shapes.AddPicture(...) method, Excel gives it a name "Picture 1", "Picture 2" etc automatically. This name can be used to get a reference to this shape object in Shapes collection like Shapes.Item("Picture 1"). If the name is changed in Excel using the Name Box, there are two diff...
Hi guys, I need a way to convert my excel files to pdf that can have any no of rows. but the no of rows per each page is a constant and each page should have an image in the footer. an example would be if i have 150 rows and the constants per page is 100 then i need to get a pdf file with two pages and each of these pages should have a...
I want read only excel sheet after creating it using poi HSSF. Please help, thanks in advance. ...