Hi, I'm trying to generate an excel file using html in php and responding with an excel Content-type. Everything works fine except new lines within a cell . They are not preserved. I've tried ; ; \r\n ,chr(13).chr(10) and it didn't work. I'm trying to get the same result from alt + enter from microsoft Excel . I am generating in a ce...
My Access programming is a little rusty, & I've never worked with Excel files all that much. I have a requirement to bring data from Excel spreadsheets into Access 2007. These spreadsheets have a fixed (predictable) format, but it includes a "header area" where I need to read single data items from specific cells, followed by a mass of ...
I am trying to generate an xls file with Spreadsheet::SimpleExcel that calls a function that is defined in a third party add in (Bloomberg, if it matters). The underlying WriteExcel package does not let me write this out because it does not know about this add-in function. I see the giant hash table of built-in functions that the modul...
i want to read the CSV file and initialise the data with objects... any one help it... ...
Hi, I want to write a bash script for a mac which takes a text file containing a table of numbers (can be .csv), converts the numbers to a chart, saves the chart (any file format that I can display on my web page), and exits. It must do this unattended. No user interaction. I know bash, perl, and a little AppleScript, and I can learn...
I know how to add a link to a button in Adobe Flash... But how exactly do I add an _onClick() event to execute a Microsoft Excel sub macro? I have a web browser form in an excel sheet. Excel allows you to draw a browser form on the page and link it to a page (e.g. stackoverflow.com) so stackoverflow.com will show in the browser fram...
Basically, I want to loop through the edges in the Borders collection. is there any "for each" way to do this? Private Function getCellBorder(ByVal vArg As Range) As String For Each Edge in Borders Debug.Print vArg.Borders(Edge).LineStyle Next Edge End Function ...
I am generating a CSV file which I then open in Excel via OLE Automation. Because of the format of the data, Excel shows many "Inconsistent Formula" warnings (a green icon in corner of each cell). I can turn this off application-wide via automation, using: objExcel.ErrorCheckingOptions.InconsistentFormula = false But doing so updates...
I want to create a Function in my C# code, which can be called from VB as if it were a Macro. i.e. the VB code should be able to do: sub vb_method csharp_method("some_parameters") end sub and have that call my C# method: public object csharp_method(String parameter) { ... } I know this can be done in C++: LPXLOPER retval;...
Hey, I have been experimenting with creating an Excel add in in C#. I was wondering if it is possible to programatically create a drop down list for a column where the items do not have to be in the worksheet? That is, I know it can be done using a data validation and a range of cells but I do not want the list of drop down items to b...
Hi there, How to obtain a list of named range exist in a specific worksheet that start with particular string (for example all named range that start with total) and grab the value? I am trying to do Sub Total and Grand Total of accommodation cost based on the date. I will assign an unique name for each Sub Total based on the Date group...
I'm working on an Excel add-in and I'm using the Excel COM interface to do automate some testing. So I'll do something like (all through calls to the Excel COM interface): Create a new Excel instance Load my XLL add-in Create a workbook Set some worksheet formulae Check that I get the expected results Now I want to test that my add-...
Hi, I'm looking for a way to load more recent data as date x in Power Pivot and link/add them to an existing table. Background: The user downloads data from a datafeed and saves them in Excel Power Pivot. The data will be deleted from the server afterwards. In the next step, new data must be added to the existing table in Power Pivot...
Good morning, Does anyone know if there is an easy way I can use a SQL query in Excel to select specific data from an Excel spreadsheet without having to use VBA, Access, an SQL database or complicated Excel formula? Thank you very much. ...
Hello, I am currently looking for git clients for Mac OSX, I have tried the following: GitX (Didn't like it.. doesn't seem functional enough) Git Gui / GitK.. (Butt Ugly! i mean yuuuuuck! and not user friendly) Source Tree (By far the best but still lacking somewhat) Is there a functionally equivalent nice looking "versions" or "cor...
Hello, I would like to create a JTable whose global layout would look somewhat like excel's. Here is an example of what I am trying to obtain (top) and where I am at the moment(bottom). To get this result I used the Groupable Header's code from crionics.com, but as you can see components of the header are not aligned vertically. Moreo...
The following code sample worked just fine in Excel 2007, but when I installed Excel 2010 (32bit) it would leave the excel.exe process open unless I added the GC.Collect(). My simple question is am I doing something wrong? It looks like to me like I am releasing everything I use. public override void Update() { StatusBo...
Hi Guys, Im trying to extract rows from excel using Oledb. For some excel files from certain people is throwing error while trying to open the connection. The error says "External table is not in the expected format." Here is my connection string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.xls;Extended Properties="Excel 8.0;H...
I have a Perl script that reads data from an Excel (xls) binary file. But the client that sends us these files has started sending us XLSX format files at times. I've updated the script to be able to read those as well. However, the client sometimes likes to name the XLSX files with an .xls extension, which currently confuses the heck...
I have an Access database with ~30 tables. How can I export all 30 tables into separate sheets in an Excel workbook? I'm hoping to find some VBA/VBS code which I can run from within Access to accomplish this task. Any ideas? ...