I need to combine several tab-separated value (TSV) files into an Excel 2007 (XLSX) spreadsheet, preferably using Python. There is not much cleverness needed in combining them - just copying each TSV file onto a separate sheet in Excel will do. Of course, the data needs to be split into columns and rows same as Excel does when I manually...
Eg. Searching for value "A" which is in A1. And moving to the next cell B1 and displaying it. How would I go about doing that? Thanks! ...
Uploaded Excel file Is In HttpPostedFileBase object HttpPostedFileBase hpf = Request.Files["ExcelFileeUploader"]; Want To Read Excel Data From This Object. thanks. ...
The problem my application is trying to solve is this: Currently, several stored procedures are run, the data is manually copied out of the SQL results into a blank spreadsheet, and reporting analysts format the data. This process has been deemed too long and costly. The ideal solution (in my mind) is a .NET application with a componen...
Using Access VBA, I want to open an XL file, do stuff, then close it without closing other XL files that are open. Option 1: If the last line is "ObjXL.Application.Quit", that closes ALL open Excel files, not just the current one. Option 2: If the last line is "ObjXL.Close", then the workbook closes, but that particular instance of XL ...
Hello. I have images within an excel file, that I need to manually extract. I have written a program which functions very well for our users with Excel 2007, but will not work with Excel 2003. Process: User Opens Excel File, Copies Relevant Image to Clipboard User Opens C# Application, Clicks Button Which Gathers Image from Clipboard, ...
I'm developing a java app that exports data to CSV files, intended to be opened in Excel by end users. We just noticed that the export function uses Java's platform default encoding. This causes umlaut characters to be lost and unit test to fail on the build server (which is configured to have US-ASCII as its platform default encoding ex...
I want to develop a small tool which for open XML file and launch Excel automatically. The benefit for user who could save the excel file to .xls format very conveniently. My Dev IDE: Windows XP pro & Visual Studio 2005. The tool will running at Windows 2000 & Excel 2000. and there is no .net framework installed. That means i can't c...
I have an Excel addin written in C# that imports a text file into Excel worksheet. Some of the fields in the file are text and some oare numbers. Problem Steps: Change the System's Regional Settings to Dutch (Belgium) Open Excel and import the file into Excel. Records contain values such as 78,1118 which gets converted to 781.118. Not...
Hi, I'm using HSSF-POI for reading excel data. The problem is I have values in a cell that look like a number but really are strings. If I look at the format cell in Excel, it says the type is "text". Still the HSSF Cell thinks it's numeric. How can I get the value as a string? If I try to use cell.getRichStringValue, I get exception; i...
I have a spreadsheet, the contents of which I would like to include as an xml plist in my Xcode project. However, I can't figure out how to actually perform the export from Excel and the import into Xcode. Any help would be greatly appreciated please. ...
Can I host an instance of excel application within a winforms application? Meaning, I want to use the excel as my datagrid in a winforms application. thank you for your input. ...
I've need to find the average and standard deviation of a large amount of data in this format. I tried using Excel but there doesn't appear to be an easy way to transpose the columns. What am I missing in Excel or should I just use Perl? Input file format is: 0 123 0 234 0 456 1 657 1 234 1 543 Want result to group the...
=RANK(F9,$F$5:$F$27,($A$43)) Can anyone help please. In the Rank formula above 'A43' refers to a cell whose value will constantly chnage between 1 and 22, depending on a time function. How do I tell the Rank formula to get the Rank Postion required from cell A43? ...
What is an Excel macro that will check every cell in column A for whether they have unique numbers or are blank? ...
I'm working with JasperReports 3.2. I have a report that I export to PDF and Excel. The report uses custom styles introduced by the user. I parse the styles in Java as it's explained here. so a sample text from the report before being interpreted is Test<style isBold="true" pdfFontName="verdanab.ttf">Test Bold</style> Some text <style i...
How to upload a excel's data into a List or DataTable without saving and then deleting the excel file? I use asp.net C#. For example, I have a excel file with some data, and I want to get the data from the excel file into a List or DataTable without saving the excel into a file system and then deleting the excel file. So I can avoid th...
I use excel a lot to structure finite state machines. As such I often format cells so that I can cut and past entire sections into my C source directly. Currently I'm having to preprocess one of my code blocks so that I can replace "-" with "_" in my identifiers. Example, in cell I might have #define Some-preprocessor-name But I'd l...
I want the column and data-type of a table in VBA ms access form how to do it easily? ...
I need a excel-like grid control in MFC, do anyone have good suggestion to implement that ?] with the control i can filter the data by clicking on the header, then it will display distinct data of current column for selection. Thanks! ...