How to export report data from SQL/ASP.NET to .XLS download with color and formatting?
Would like to be able to set colors of headings and such, different font sizes and background colors for cells. C# please. ...
xls
CSV to XLS linux script
I need a script to convert a comma seperated csv file to an excel xls file. I tried a python script online but i couldn't install the correct version of python to install a mod/dependency the script required. What is the best solution? ...
XSLT - XML to XLS
I have an XSLT template that gets applied to an XML file of data. The template generates an Excel Spreadsheet XML file. Everything works wonderful except for one minor issue.... When I open the spreadsheet in Excel, it treats it as an XML import and asks me whether the stylesheet should be applied. I would like to have it so it autom...
What is the tab name when loading XLS file into vb 2008?
I am trying to load an Excel 97 single tabbed spreadsheet into a SQL server table using the OleDbDataAdapter function. From all the documentation I have found, the first parameter should be "select * from [sheet1$]". This works fine for me only if the tab in the worksheet is named Sheet1. If I change what's in the [] brackets to the a...
Read a value from a .xls file using .bat files
Hi, I just want to know if there could be any way by which we can read a value from an .xls file using a .bat file. For eg:If i have an .xls named test.xls which is having two columns namely 'EID' and then 'mail ID'.Now when we give the input to the .xls the EID name.it should extract the mail id which corresponds to the EID and ec...
php,xml,ups shipping: "Cannot view XML input using XSL..." Where's the bug?
Hey, so I'm deploying a shipping calculator using this function, and I'm getting this error only when I use IE. Firefox does just fine with the shipping calculator. I'm unfamiliar with this error, and google searches tell me that it's a problem with the xml format. Problem is: the XML response from UPS's shipping calculation server shoul...
Protect excel file with java
Is there a way to create open protected excel file in Java? I'm looking at JExcelApi and Apache Poi projects but with both of them I cannot figure out how to protect generated xls file. I want to assure that generated file can be opened only by people that know password phrase. ...
How can I modify an existing Excel workbook with Perl?
With Spreadsheet::WriteExcel, I can create a new workbook, but what if I want to open an existing book and modify certain columns? How would I accomplish that? I could parse all of the data out of the sheet using Spreadsheet::ParseExcel then write it back with new values in certain rows/columns using Spreadsheet::WriteExcel, however. Is...
When I export files with php/html my session data resets
I have a web-based system built with user login data based on session variables. Sometimes when a user is logged in and tries to export tables to csv or xls the session data seems to wipe and the user is 'kicked out' of the system. This is the header code I'm using to serve the file. header("Pragma: public"); header("Expires: ...
How to Highlight Row in XSL file without Opening EXCEL using C#
Hi, I have an XSL file that I am generating from CSV from and Object etc. etc. Everything is done except that I need to highlight particular rows in the xsl file. I don't want to have to open Excel and use Macros. Is there a way to do this in C#? ...
Character encoding issues when reading XLS files with PHP
I'm using the PHP-Excel-Reader library to read some XLS files and immediately have hit this issue: PHP Notice: iconv() [function.iconv]: Detected an incomplete multibyte character in input string in C:\web\docs\housing\excel_reader2.php on line 1718 The line in question is this: $result = iconv('UTF-16LE', $this->_defaultEncoding...
export mysql result to excel..
Hi all, I found a little script that will export information to an xls file, but I can't seem to get it working. The original code is found here: http://www.appservnetwork.com/modules.php?name=News&file=article&sid=8 And here's my code: // Query Database $query = 'SELECT * FROM #__db_clients WHERE published = '1' AND companyid ...
window.location.href does not work in Internet Explorer with XLS files
I have a legacy application that, at some point, generates the following code in one of its pages: window.location.href = "http://localhost:8080/myApplication/manuals/charts.xls"; When Mozilla sees this, it opens a download dialog with "open with...\save as..." options. IE (v7 and v8) does not open a dialog. It takes the file and jus...
Error while loading xls file in MATLAB
I am trying to load an xls file in MATLAB. The xls file contains numerical values. I have successfully loaded and plotted the file but if I change the dimensions of the file (i.e. number of rows and number of columns) there is an error: Numeric = xlsread('Test_results_new') ??? No appropriate method or public field UsedRange for class I...
Where to put to_xls and from_xls in a rails app
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...
Convert excel document (xls) to a plist
I have a pretty straightforward excel document in which I need to use the data in an iPhone app. The xls document has 6 columns, 200 plus rows. I would like to create a plist from the xls document and other than manual copy/paste, is there a means to convert one to the other? Anyone written a macro on the excel side or a utility (per...
MyXls lib doesn't edit existing file
Trying to edit my file with MyXls: XlsDocument doc = new XlsDocument(InputFilePath); Worksheet sheet = doc.Workbook.Worksheets[InputSheet.Substring(0, InputSheet.Length - 1)]; foreach (var row in sheet) { if (row.CellCount > 1) { Cell firstCell = row.GetCell(1); ...
xsl:template match for xml with prefixes
I have this xml file <?xml version="1.0" encoding="UTF-8"?> <bo:C837ClaimParent xsi:type="bo:C837ClaimParent" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bo="http://somelongpathHere/process/bo"> <claimAux> ... </claimAux> <enterpriseClaim> ... <patientAccountNumber>data to capture here</patientAccountNumbe...
ASP.NET - Rendering Gridview to HtmlTextWriter - XLS - Column Format
I'm using the following code to render a gridview to an XLS file on an ASPX page: Private Sub ExportGridviewToExcel() Dim attachment As String = "attachment; filename=ItemSizeExport.xls" Response.ClearContent() Response.AddHeader("content-disposition", attachment) Response.ContentType = "application/ms-excel" Dim sw ...
Read XLS file from VB6
How can I read an XLS file from VB6? I don't want to use ADO or Automation. ADO isn't going to work for my particular XLS files, because it guesses the data types of the columns from the data in the first few rows. Automation is out, because Excel may not be installed on the machine. I'm hoping for recommendations based on experie...