excel

Export to xls in customised way.

My application is fetching a data dynamically from MYSQL and displaying. The Problem is even i have to give the option to "Export to Xls" file. And these file should be in a A4 size, so i should customize the font size of contents in the Xls file to fit into the A4 size.And i need to insert if possible image into the file. Please help m...

excel - auto balance from previous balance and value

Hi, I've never realy used excel before and I thought I'd use it to store my account details. I was wondering if someone could help me with a formula. Let's say column A contains balance and and B value (transaction value of a negative or positive number). I'm looking for the balance to automatically work itself out. From what I can g...

exporting text file to excel to plot a graph using 'C' program

Hi I am storing samples using a text file in my C program. I want to plot a waveform using those values in excel. How can I export data to excel from program???How can I do that??? otherwise Is there any other way to plot waveform in C program itself??? Thanks in advance... ...

How do I create a multi-cell array formula in Excel whose input is just one cell?

I have a cell with a spaced delimited string say "NULL 9" Say this data is stored in A1. I have a function called Function splitCell(str As String) As String() splitCell = split(str, " ") End Function I am trying to break the cell into a string array, what I then want to do is to have a formula such as {=splitCell(A1)} at the lo...

Check if a column is a certain value otherwise require value input in Excel.

I have an Excel document that contains 8 columns for testing at work like so: Name | First Try | Second Try | Final Score | P/F (Last, First) | Points | Percent | Points | Percent | Points | Percent | --------------------------------------------------------------------------------- I have the percent...

excel autofilter crashes on browser

i am able to open excel files directly on web browser via some configuration on windows. (eg : www.xyz.com/excelfile.xlsx) it opens on ie 8. My problem is when i use autofilter columns in excel files,when i try to filter rows on excel int. explorer crashes somehow. here are some eventvwr logs,what might cause this error ? i even tried ...

Excel Macro: Select cells on condition and use as data validation list

Hi, I'd like to select all cells (except the first one) from column A of sheet B that are not empty, and use it as the list for data validation on a range of sheet A. I already have code to add the validation: Cells.SpecialCells(xlCellTypeFormulas).Offset(0, 1).Select With Selection.Validation .Delete .Add Type:=xlValidateList,...

Import excel file with asp.net

Hi there, I'm working on an asp.net /c# app I need my app to allow users to upload .XLS files (located on the user machine). How can i read data from the .XLS file but without saving the file on server? tks ...

How to get value from textfield in powerpoint into excel?

How could this be done? The powerpoint application is running and the textfield i want to get the value from is on slide3. I've tried this without any success: Dim PPApp As PowerPoint.Application Set PPApp = GetObject(, "PowerPoint.Application") Range("A20").Value = PPApp.Presentation.Slide3.txtMyTextField.Value Anyone know the rig...

ado.net excel plans(tables) order

I'm creating a .exe in C# to import data from Excel and insert into my DataBase. This Excel file has in each column the name and the values below and for each Table in DB it has a sub table(those that are changed on the bottom of the page in Excel) with the table name. It's working fine, but one of the tables in my DataBase has a forei...

Fill Out PDF Forms from an Excel Array

The scenario is this: My company has 2000 customers, and we need to send the all 2000 customers a credit application via PDF. What complicates this is that certain parts of the PDF need to have customer data filled in before the form is sent to the customer. The data that needs to be filled in is currently inside of an Excel array. As...

VBA Findnext Issue

This code works until input the coding between the ********** I'm trying to do two different searches at the same time. Can someone explain what I'm doing wrong? Thanks Public Sub Swap() With Sheet1.Range("A:A") Set LastCell = .Cells(.Cells.Count) End With Set FoundCell = Sheet1.Range("A:A").Find(what:=cusip, after:=LastCell) If...

Save Excel 2003 worksheet into an Access 2003 table

I'm trying to write a macro to export a single row from a single worksheet from an Excel 2003 workbook to a new row in an Access 2003 table. I'm new to VBA, and everything I've found on the web refers to going the other way -- from Access to Excel. I want this to be an export, not a link, and I don't care about keeping them synced afte...

SQL query returning list of data that needs to be grouped

I am trying to pull some data out of our testing database with an sql query and i am stuck. Below is a representation of how the data looks when I run it and how it should look once it is run. What I get Sample_Number Centre_Code DateEntered AssayName --------------------------------------------------- 1 234 9...

Filter Multiple Pivot Table Separately In Excel 2010

How can I have multiple Pivot Table and Charts from the same source and use separate grouping and filtering for each one? I have two charts: one I want to show Weekly data and the other should show Monthly data. Whenever I change one, it updates the other. ...

C# - How to copy a single Excel worksheet from one workbook to another?

Hey all, I have a need to copy a worksheet from one workbook into another and I'm a bit stuck. The premise is that I have a "master" workbook that stores the templates for a number of reports and I then need to create a blank copy of a specific worksheet and add it into a new workbook. This is what I have so far: private void CreateN...

excel shared formula expansion

Hi. I am using the OpenXML libraries from C# to read Excel files. One of my requirements is to be able to show the exact formula for each cell that has one. The OpenXML encoded file uses "shared formulas" to reduce file size. Like this: D3 : <x:f t="shared" ref="D3:D6" si="1" >D2+C3</x:f><x:v >130</x:v> D4 : <x:f t="shared" si="1" />...

How to make WPF App as OLE object which can embedded in MS Excel ?

I want to make my WPF app as an OLE object which can be inserted and launched from an MS-Excel . When I open an Excel-2003 and go to Insert->Object a list of OLE object are shown in Create New tab. I want to register my WPF app as an OLE object so that it is also shown in the list. User can able to insert and launch the appliction from ...

How do I display a worksheet by name using VSTO 2010 for Excel

I have never used VSTO and I am finding it difficult to find a good learning aid for 2010. My need is simple, I have a business workbook with 42 worksheets (I orignally guessed 20 but after counting found a surprising number). I want to add a ribbon (That part is easy) using VSTO to allow employees to navigate the large number of pages...

Excel VBA - Using Ranges as Optional parameters for functions?

I'd like to write a VBA function that has a Range as an optional parameter. For instance something like: Public Function testfunc(S As String, Optional R As Range) As String testfunc = S For Each cell In R testfunc = testfunc + cell Next cell End Function I tried the function above, but I get a #VALUE! error. I also tried wrapping the...