I run a report every week and would like to cut the rows for a particular date range into a new worksheet (i.e. all rows with transactions between the 16th of one month to the 15th of the following month). I'd like to cut all rows between 07/16 and 08/15 and past them in a new worksheet called "Aug" And cut all rows between 08/16 and 09...
I have this script that I'd like to in addition save as a xls file, also save as a .txt in the same directory, or even a different one. Can I get some guidance here? Imports System.IO Module Module1 Private Property fs As Object Private Property BaseName As Object Private Property FullTargetPath As Object Sub Main() Dim targ...
Via VB.Net, is there any way to access the AutoSum feature that Excel has? I have a spreadsheet that I create and populate via a datatable using my application. I know how to sum based upon a predefined range (e.g., .cells(cnt + 1, 21).Formula = "=Sum(U3:U" & cnt & ")") but is there any way that I can just call a cell in my worksheet an...
Date format is 1:55:25 AM in the excel file, after reading using ExcelReaderFactory.CreateBinaryReader, I get the 0.0451388888888889. ...
Hi I've created a worksheet which is shared amongst my colleagues with a real simply macro to show/hide rows but everytime either I or one of my colleagues opens it they get prompted to Allow marco - is there anyway for them to permantly allow this macro? ...
Is it possible to find percentile of a) a column called "Country" with text based column values b) a column called "Salary" with column values either of the following - <=50K, >50K ...
What are the set excel formula for calculating 1) Median Absolute Difference MAD ...
Hello, I have looked into every nook and simply cannot find the exit here, so if anybody can, please provide some insight.. (Mac OSX user - MS Excel 2008 (no VBA) I have a list of content categories (string) from different sources (index) and my task is to create a list for a mapping document that will concatenate (or not) each row fro...
Hi, I have a pivot table created from 3 fields where (for example): field1 values are: "1", "3", "5" field2 values are: "A", "B", "C" field3 values are: "X", "Y", "Z" So given a pivot table PT1 I want to reference a cell within the table in a similar way to PT1["1"]["B"]["Y"] and get a Range item returned. Is this possible? Thanks. ED...
Hi! On the project which I am currently working, I have to read an Excel file (with over a 1000 rows), extract all them and insert/update to a database table. 1ª Question: in terms of performance, is better to add all the records to a Doctrine_Collection and insert/update them after using the fromArray() method, right? One other possib...
I have a excel sheet with cell value 0.010, 0.020 etc., I want to get the values 3 digits after the decimal ie., "010" "020" etc., If I use the Right function Right(cell,3) it returns me ".01" ".02". The reason is the Right function ignores the "0" at the end of decimal point. Is there any other function that accomplish this. ...
hi, i've in my excel file a sheet with 3 columns (id,type,month). knowing that many items appearing more than once, i need to get the number of occurances of each id per month then to get the number of ids appearing twice, appearing three times, ... i was told that pivot table is the solution. so i created a pivot table with macro rec...
I am generating OpenXml using the DocumentFormat.OpenXML library from Microsoft. I am tring to figure out how to get this document into my clipboard so that I can paste my data into Excel (as if it were copied from Excel). I am able to see OpenXml formated data coming out of Excel, when I copy from within Excel. I need to do the reverse,...
I have 5 sheets in my workbook.Whenever I make a change in any of the sheets cell I want to record the change and create new log sheet with sheet name, which cell was updated,what is the updated value etc. How can I do this ...
Hi, On this page it generates a Excel sheet and allows user to download that. But as shown below it does not work properly on IE (both 7 & 8) this works fine with Firefox,chrome and safari. Is there any settings we can do on both client side or Server side. image location thank you ...
I'm working on a long list of data (Column B) that has been formatted using bold and indents. The bold cells contain the titles/category names and the indented cell values are the subcategories. The row heights are all over the place. It should have been 10.5 for everything, and the bold cells/rows 15. I can change everything to 10.5, b...
I'm currenlty putting together an If, ElseIf and Else statement to go through the lists and make it standard. The parts where I'm struggling are those cells where a superscript character has been used at the end of the sentaence for footnote references. These cells need to be given specific line heights different from the standard 10.5. ...
I have an Excel 2007 workbook that contains an ODBC data connection (to FoxPro, if that matters). The connection is set to "refresh data when opening the file." When I go into File Explorer and open the workbook, the data populates into the spreadsheet as it should. However, when I execute a function in Access VBA that opens the workboo...
In a WPF application, I need to generate data that can be put on the clipboard and pasted into excel. I need to paste something that can carry over data and formulas. I was attempting OpenXML... but I'm not sure that works. I am currently attempting to make raw "Spreadsheet ML" (This is different than OpenXML?) Anyway, if anyone coul...
Hi all I'd like to find a cell in an Excel sheet by its text. The text is something like %t: sheet.findCell("%t"); // pseudo-code, not working My goal is to enable the user to provide kind of template, in which data is written. Colours and fonts, as well as data's position can be configured by the user in an Excel file. This %t cell ...