Search Results

Search found 67192 results on 2688 pages for 'excel external data'.

Page 280/2688 | < Previous Page | 276 277 278 279 280 281 282 283 284 285 286 287  | Next Page >

• Looking for a good text parsing library for C#

  - by Chris Stewart

  Has anyone run across a quality library that will parse, line by line, CSV, tab-delimited, and Excel files? I've started to do it manually but have noticed some of the intricacies in parsing a comma-delimited file. Such as situations where a cell has a comma in it as part of the data (blah,\"LastName, Jr.\",blah,blah).

  Read the article

• How can I create a new spreadsheet file using the OOXML SDK that contains multiple worksheets?

  - by Shawn Simon

  I downloaded the OOXML SDK. I need to create a simple excel spreadsheet that has x worksheets, each with 4 columns and y rows of data. It's pretty simple, but I can't find an example of how to create sheets anywhere. I am going absolutely insane here. Thanks

  Read the article

• Adding buttons to spreadsheets in .NET (VSTO)

  - by mcoolbeth

  Using VSTO or some related technology, is it possible to programmatically embed a button in a cell of an Excel worksheet, and configure it to call a C# function when it is clicked? How? Thanks.

  Read the article

• How to select part of a text that exists already in an above cell

  - by pragadheesh

  Hi, In MS Excel, consider i have the word 'Microsoft' in a cell. And in the cell below I want to type the word 'Microhard'. When I start typing Microhard, the word Microsoft appears shaded in black. Now how can I select the part 'Micro' alone from Microsoft and type 'hard' alone. Hope my question is clear.

  Read the article

• Spreadsheet::WriteExcel Memory Usage

  - by Stomped

  Hi; I'm trying to create a multi-sheet excel document, and thus far I'd been doing it in PHP - but using PHPExcel was eating up 70MB of RAM for about 60,000 spreadsheet cells total. I'm wondering if anyone has experience with Spreadsheet::WriteExcel and if it has problems with creating very large documents. I'd just give it a shot but I'm very inexperienced with Perl and it could take me quite a bit of time to get this up and rolling even if for a test, and I thought someone here might have insight for me.

  Read the article

• How do I convert an XLS document to XML in C#?

  - by oraclee

  Hi all. I have an Excel spreadsheet that looks like: I'd like to convert this to some XML that looks like: <UserName> bla1 </UserName> <Mail> bla1[at]bla2.com </Mail> <Address> World </Address> can anyone help me do this in C#?

  Read the article

• Keep rows hidden even when a table filter option is selected in Excel2007

  - by Srin

  I have a Excel Table (Range formatted as table) I have some rows set as Hidden in the table. the table header have filter option and when i select a filter item, the hidden rows are becoming visibe. Is there any option / vba method to keep the hidden rows hidden ? Ideas pls....

  Read the article

• If/Then in SQL Embedded in VBA

  - by Daniel

  I've got a string like this in my Excel VBA: strSQL = "SELECT * FROM Total WHERE (SimulationID = (" & TextBox1.Text & ") And Test1 = (" & Example & "))" However, sometimes Test will be 'is null', which makes the query And Example = is NULL How can I change it to add an if/then statement or something to make it say And Example is null when Example has a value of "is null"?

  Read the article

• System.Runtime.InteropServices.COMException : This command is unavailable because the license to use

  - by sam

  I am running 3 virtual machines that are running tests using cc.net server. Currently tests are running simultanously on 3 machines. All the tests require to access Excel file. When tests run individually they all work fine but running them on virtual server is causing this error. Any idea how to resolve this issue.

  Read the article

• SQL statement to grab table names, views, and stored procs, order by schema

  - by sunpech

  Is there a SQL statement that will list the names of all the tables, views, and stored procs from MS SQL Server database, ordered by schema name? I would like to generate an Excel spreadsheet from this list with the columns: schema, type (table, view, stored proc), and name.

  Read the article

• Read xlsx file in Java

  - by MrPortico

  I need to read a Excel 2007 xlsx file in a java application. Does anyone know of a good api to accomplish this task? Thanks in advance for any advice given. -MrPortico

  Read the article

• Convert to date

  - by comii

  Hi! How i can convert number 20020415 to date 15.04.2002. I am working in Microsoft Excel 2003? Thanks!

  Read the article

• google products

  - by joesalvator

  Please help I am trying to get my products on google products and i keep getting disprove and its says disprove because of text but followed the format they said to use (make a excel sheet with id, title,etc.) then save as tab text. then upload the data feed

  Read the article

• stop 2nd question after save to XML format?

  - by Anastasia

  How can i get my Excel xls file that is password protected to stop asking me if i want to convert it to an XML file format?

  Read the article

• C# Best way to read a XLS (XLSX) file and populate a datagrid

  - by LeeW

  Hi all, What is the best (free or paid for) to read Excel files (XLS and XLSX) using C# and populate a datagrid, I would also like to have any changes made in the datagrid be written back to the file. This would be used for a commercial application so it would need to be distributable. Thanks Lee

  Read the article

• first Occurrence Of Non Blank Cell vba

  - by Madhu Kiran

  Hi, I am trying to write VBA code which works on my Excel sheet. Range("A65536").End(xlUp).Row gives me the row number of the last non blank cell. similarly i am trying to get the row number of the first non blank cell in that particular column. Thanks in advance. madhu

  Read the article

• Important packages and modules not compatible with py2exe?

  - by EOL

  Are there major/common/important packages that py2exe cannot handle? I am currently studying the possibility of creating a .exe from a Python program that will use Tkinter, some Excel file reading module, NumPy, SciPy and matplotlib: is it realistic to try to achieve this with py2exe?

  Read the article

• How to get points that intersect the treadline?

  - by chutsu

  Basically I did the Cavendish experiment, and I have a damped sinusoidal wave plotted on Excel. With Position (mm) against Time (s). My problem is that I have added a tread line through the wave function, and wish to calculate the points of which the wave function intersects the tread line. From this I will then be able to calculate the time period. At the moment I'm just having difficulty getting the intersects.. Thanks

  Read the article

• How can I get WorkbookPart from WorkSheet ?

  - by Ant

  Hi, I am trying to create Excel file using OpenXML SDK. I have one situation to get WorkBookPart from WorkSheet instance. How can I get it? Thanks. Ant.

  Read the article

• (Pivot) tables generation

  - by Yasir Arsanukaev

  Hello. We use Excel VBA to load data using SQL, process it and generate (pivot) tables. I wonder if there any other decent alternatives. I've been thinking on PDF generation but not sure if there are handy tools to construct pivot tables. Important requirement is the ability to print data correctly, so that everything fits on the page(s). Thanks.

  Read the article

• CSV is not creating format problems with integer value when generated through SSIS package

  - by paranjai

  Hi I am trying to generate a CSV file from DB Query as source one of my column is having datatype nvarchar(50) with values as "01050007029604301001" After the export when the csv file is viewed using Excel the value appears as "1.0500E18" . How can i stop this . Please suggest

  Read the article

• Excelsheet query

  - by kunj

  Hi, Please tell me how can I find the last word from any particular cell in excel sheet if cell contains multiple words or instructions. For ex- The below string is in particular cell: C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg My requirement is to search only last word in that cell i.e. Blue hills.jpg Your early response is highly appreciated!!!

  Read the article

• How to retrieve values of an enumeration of given string literal

  - by TonyP

  Need to get a value of an enumeration of a given string literal like "xlCenter" (these values are cut and pasted from Excel Macro). I would like to retrieve the actual constant value (int) -4108="xLCenter" via com marshaling is this possible ? if so how ? Ideally I am looking for function like this public int ExcelConstant(string constantName) { ...} Thanks

  Read the article

• Using IF LARGE when there is text in column

  - by Ray

  I have an excel column of numbers and texts. I tried to use "IF LARGE" to find top 3 numbers of the column (A1 to A7), and return "Yes" to the cells right next to the top 3 (in column B). But unfortunately, the cells next to the texts also returned "Yes". This is the data: 0.2 0.3 Yes 0.5 Yes 0.1 0.8 Yes asdf Yes jklm Yes This is the code for cell B7: =IF(A7>=LARGE($A$1:$A$7,3),"Yes","") Any suggestions to fix this? thanks in advance

  Read the article

• VSTO: How to refresh a formula when a cell value changes

  - by Bob

  Hi there, Let's say I have the formula =MyCustomFunction(D2), where MyCustomFunction is writen in an Excel AddIn using C# How can I, in a sensible way, tell my formula to re-run when cell D2 is changed?

  Read the article

< Previous Page | 276 277 278 279 280 281 282 283 284 285 286 287  | Next Page >