So I have a model that I need to be able to serialize to/read from an Excel(XLS) document. I am a bit of a loss as to where this code actually belongs. My initial thought is that the to_xls is a view, but after poking around and seeing things like (to|from)_xml and (to|from)_json in ActiveRecord, I was wondering if maybe this stuff belon...
Hello, I generate some Excel file from an .NET C# application. I use PIA 2002. I can password protect, do a freeze pane, change the color of the cells .... one thing I can't do. I'd like to allow for a specific range, the use can enter ONLY a number..... How can I do this ? Thanks, ...
I have an ASP.Net website that allows you to export a Gridview to Excel. The Gridview has some column headings with words and then numbers surrounded by parentheses like this: Abc<br>(43) Xyz<br>(55) I have set the bound field's HtmlEncode property to False because I do not want it to escape the line break tags I have in there. This i...
In my app, I'm downloading a spreadsheet from FTP, moving the data read from the spreadsheet to a DataTable, and, depending on certain conditions, emailing a new spreadsheet (one that contains certain rows from the 1st spreadsheet). My problem is creating the spreadsheet that will be mailed. I can't seem to work out how to add the row f...
HAI i want ot convert a cell text value into a number in Excel using POI API. cell text value like '2,345' to conver as a number. How can i do that. if any has face this problem,please let me know... ...
Hi to all , I am using ExcelPackage to create the excel sheet through .net. I am taking the reference at codeplex for creating excel sheet. It is giving me following error: A required privilege is not held by the client. at the line when creating object of FileInfo class as FileInfo newFile = new FileInfo(@"C:\mynewfile.xlsx"); ...
Hi everyone, I have to export some data, stored in a MSSQL database, using Coldfusion server pages. I setup my query with the cfquery tag, I generate my cfr file in Report Builder and setup the cfreport tag like this: <cfquery name="q" datasource="mydsn"> SELECT * FROM table </cfquery> <cfreport format="EXCEL" template="cfrPath/cfrfil...
I have an Xceed datagrid v2(express) bound to a list of viewmodels. Each viewmodel consists of several types of objects. For example a viewmodel with a specific contact and its employer object. In the grid I show the contact information and some employer information. What I want to do is get the information shown in the grid instead of...
Say I have stored a query in a variable called $query. I want to create small hyper link called "export as CSV" on the results page. How do i do this? ...
How do I export data in my datagrid to an Excel file in Flex? Can anyone provide some examples for that? I am browsing but couldn't find out a single example of that kind. EDIT Browsed a lot and found out how to convert datagrid data to csv format. Now How to convert that to excel? Is there a way to do that without using any server sc...
The ListBox contains multiple ListBoxes which inturn contain many ListBoxItems. The top level ListBox does not have a ItemsSource collection bound to it, rather the child ListBoxes have ListBoxItems that are bound to individual properties in the VM. Is there a way to just dump the ListBox "contents" to an Excel file, may be by converting...
I need to create a program that can read from/write to an Excel file. Should I use OleDB or use an Excel Object? What are the advantages of one over another, and where can I read up to get started on implementing this? ...
When I Run a Query, the results of it are exported to the Excel. This data has few hyperlinks which get displayed in random (I donno which cell or column). My Issue is that the hyperlinks are getting displayed as normal word and not as clickable hyperlinks. Unless, i click on the particular cell and click outside, the hyperlink doesn't b...
Yesterday I found this How-To on exporting data to Excel spreadsheets by simply producing HTML. Seemed like a straightforward way of exporting cells with formatting, what one can not achieve using just CSV format. My idea was to process some data in a Java app, export the results to Excel spreadsheet and make use of Excel's capabilities...
I have an ASP.NET 3.5 site that needs to export data to a pre-formatted Excel sheet. I am not allowed to modify the excel sheet in any way, just drop data into specific cells. My question is, What is the simplest way to do this from an ASP.NET site. The user will always have Excel on their machine. Is a 3rd party control my best option...
Morning all - another day, another question from Rich! I have the following scenario. I have two methods of populating a GridView with data. These are as follows: protected void btSearch_Click(object sender, EventArgs e) { lqPackWeights.WhereParameters.Clear(); ControlParameter cp = new ControlParameter(); cp.Type = TypeCo...
Here's a link to the Dashboard page that I'm trying to built (image of the old implementation) So, basically the Grid needs the following features: Parent-child cascading (only 1 level) - the yellow row are parent Grid which expand-collapse (simple js trick). The whole Grid needs to have a 'frozen' header. As you can see in the image...
I'm using JExcelApi for generating XLS files. From jxl.format.Colour, I see how to get any of the colors in the "standard Excel colour palette", but not how to create a new color (say, given its RGB). But in Excel itself, I can pick any color at all. Am I just missing it? Is there a way in JExcelApi to select an arbitrary color? I'm...
I'm using the Pear Excel Writer package to export a dataset to Excel from PHP. My problem is some of the data fields have leading zeros (such as a zip code), but these are being trimmed in Excel. I tried adding an apostrophe to the start of the fields to force a text field, but then Excel displays it, which I don't want. I'm neither a PH...
I've used RODBC for some time to import Excel spreadsheets with mostly good results. However I have had no luck writing to an Excel spreadsheet. Also are there favorable differences using the xlsx format with Excel2007? ...