Export a VirtualStringTree to excel, csv ?
Is it possible to export a VirtualStringTree to Excel or CSV? I am using Delphi 2007 and trying to save my VirtualStringTree data records as Excel or CSV format. ...
excel
Same column in two worksheets are aligned differently horizontally
I am copying a worksheet programmatically by filling in a blank sheet. One column is a dollar amount. In the original sheet, it's right aligned. In the new sheet, it's left aligned. When I do format cells to look at the format, both are Number tab = General and horizontal alignment = General. What's making them have two different kinds ...
Updating a database from an Excel speadsheet in .NET
Can Teradata tables be updated in an VB.NET application by reading an Excel spreadsheet and pulling certain values from certain columns? If so how? Thanks ...
Opening an Excel file using the default program
My program successfully creates and fills a Excel(.xls) file. Once created, I would like the new file to open in the system's default program (Excel in my case). How can I achieve this? For an older program where I wanted to open a txt file in Notepad, I used the following: if (!Desktop.isDesktopSupported()) { System.err.printl...
type of excel using SpreadXML
Hi, I have exported data as an excel file using SpreadXML from server. I saved the file as "report.xls"...but if i open the file and try to "save as", i am able to see that type file is "xml". How shud i change the type to xls while saving ...
change the format of SpreadXML type excel file
Hi, We are displaying in an XML spreadsheet data exported from an SQL server DB and if th euser clicks save without changing the format the file size is over 6 time the size of the same data in native .xls Does anyone know a way to force the save as .xls? ...
Axapta V3 - how to access worksheet.pagesetup properties from x++
Does anyone know how to access the PageSetup properities of an Excel worksheet via COM from x++ code. I can do all the formatting I require for a custom report but can't access PageSetup object. Any pointers / suggestions appreciated. ...
In Excel how to create multiple rows from a single data row
Hi I have an execl datasheet with data looking like this id desc part no 1 Qty 1 part no 2 Qty 2 part no 3 Qty 3 1 PartsName 382A012-3-0 3 382A023-3 3 382A012-25 3 And need it to look like this id desc part no Qty 1 PartsName 382A012-3-0 3 1 Part...
Deploying an Excel UDF
I have an excel UDF that calls a web service . The UDF code is an automation addin code which is a C# class library and I created an installer for it. When I run the set up, no reference to the particular addin code appears in the toos-->addins-->automation addins list of excel and the function does not apepar in the formula bar. I am us...
How to remove the recent document history in Excel Ribbon using VBA
How to remove the recent document history in Excel Ribbon using VBA. I am using the code below, but it doesn't seems to work. Sub Button1_Click() For i = 1 To Application.RecentFiles.Count - 1 Application.RecentFiles(i).Delete Next i End Sub Thanks ... ...
Reading values from an Excel File
I want to get a value from 12 excel sheet. is there any way that i get the values without opening the excel sheet? I am using vb.net. Please post an example code, if there is a way to read values without opening the excel file. thanks ...
How to get an excerpt of a table in Excel in a different table?
I have got an Excel document that is used as patient database for a practice. In the first table there is a complete list of all patients with the date of their first appointment and (if applicable) the date of their final appointment. In the second table, I would like to have a list of all current patients (no final appointment). In th...
how to use a macro to transpose data from rows into columns
I am totally new to VBA (aside from recording and running manually) so was hoping somebody could help me with designing this. I have a worksheet with unspecified # of rows per unique ID (column A), based on date and type. : A B C D 1 12Jan2010 type A Person1 1 16Jan2010 type B Person1 ...
Can we put a formula in the "value_if_true" field in an IF Function in Excel?
I have a situation where i need to put a formula in the "Value_if_true" and "Value_if_false" fields in an IF function but it does not seems to be working. It just keeps displaying my formula as is in the cell. Can someone help? ...
Microsoft Excel – How to copy cells to a different worksheet on every nth row.
Microsoft Excel – How to copy cells to a different worksheet on every nth row. I have an interesting problem. It is probably simple, but I can’t figure it out. I have a list of cells (about 10 columns across and over thousand rows, soon to be expanding) A1-A10 and down These are my headings and main input cells (let’s call this Summary...
Nested If Statements Returning zero if nothing entered in cell.
Listed below is the formula. I would like to return zero if nothing is entered in the cell.How would i do this? =IF(E6>0,F6/E6,"") ...
Excel Help: Sum or Count until?
Ok, so here's my problem... and I'll preface this by saying that I'm pretty well-versed in Excel; however, I've very little knowledge about the INDIRECT function (so if it's something obvious with the INDIRECT function, please excuse my newb-ness). I'm trying to make my Compliance Worksheet a bit more efficient. I have a list of contro...
Excel VBA Programming with Arrays: To Pass them or Not To Pass them?
Question: I am wondering which is the optimal solution for dealing with Arrays in Excel 2003 VBA Background: I have a Macro in Excel 2003 that is over 5000 lines. I have built it over the last 2 years adding new features as new Procedures, which helps to segment the code and debug, change, or add to that feature. The downside is tha...
removing the nulls from an array and copying to new array
I am splitting a line of text into an array then attempting to put into a new array without the null spaces. For some reason it's not copying from the old array into the new one. BTW if someone has a more efficient way of doing this I am open to that as well. Dim x As Variant, i As Integer, m As String, rdate As String, k(0 To 50) As V...
Someone is eating my <?xml version="1.0"?> returning an Excel XML in Asp.net MVC
I'm playing with VB XML literals for returning and Excel XML file. the problem is that the first line containing <?xml version="1.0"?> does not make to the download. Here is the code: Public Class ReservasController Function Test() Response.Clear() Response.AddHeader("Content-Disposition", "attachment; filename=test.xml") ...