Search Results

Search found 4783 results on 192 pages for 'excel vba'.

Page 71/192 | < Previous Page | 67 68 69 70 71 72 73 74 75 76 77 78  | Next Page >

• Identifying Different Excel File Formats

  - by sgibbons

  Is anyone familiar with a library or tool that can determine which format an excel file is in? Or, failing that, documentation on the different formats that would allow me to write my own?

  Read the article

• Finding contained bordered regions from Excel imports.

  - by dmaruca

  I am importing massive amounts of data from Excel that have various table layouts. I have good enough table detection routines and merge cell handling, but I am running into a problem when it comes to dealing with borders. Namely performance. The bordered regions in some of these files have meaning. Data Setup: I am importing directly from Office Open XML using VB6 and MSXML. The data is parsed from the XML into a dictionary of cell data. This wonks wonderfully and is just as fast as using docmd.transferspreadsheet in Access, but returns much better results. Each cell contains a pointer to a style element which contains a pointer to a border element that defines the visibility and weight of each border (this is how the data is structured inside OpenXML, also). Challenge: What I'm trying to do is find every region that is enclosed inside borders, and create a list of cells that are inside that region. What I have done: I initially created a BFS(breadth first search) fill routine to find these areas. This works wonderfully and fast for "normal" sized spreadsheets, but gets way too slow for imports into the thousands of rows. One problem is that a border in Excel could be stored in the cell you are checking or the opposing border in the adjacent cell. That's ok, I can consolidate that data on import to reduce the number of checks needed. One thing I thought about doing is to create a separate graph that outlines the cells using the borders as my edges and using a graph algorithm to find regions that way, but I'm having trouble figuring out how to implement the algorithm. I've used Dijkstra in the past and thought I could do similar with this. So I can span out using no endpoint to search the entire graph, and if I encounter a closed node I know that I just found an enclosed region, but how can I know if the route I've found is the optimal one? I guess I could flag that to run a separate check for the found closed node to the previous node ignoring that one edge. This could work, but wouldn't be much better performance wise on dense graphs. Can anyone else suggest a better method? Thanks for taking the time to read this.

  Read the article

• Find more than one string with Excel?

  - by TaintedLove

  How to Find more than one string with Excel with the graphical interface? For example, I am looking for the cells which is contained both strings Paul and John?

  Read the article

• Extracting the hyperlink value from an excel cell using asp.net

  - by beytz

  Hi, I'm reading an excel file using oledb in my asp.net code (vb). I have no problem going over the data but in one of the cells there is a string that "hides" a hyperlink. I want that hyperlink and not the string... Any ideas? Thanks

  Read the article

• Excel : Increment Row number on fill right

  - by soldieraman

  When one "Fills right in excel" , the Column name updates eg. 1st cell is =A2 If I fill right the next cell will be =B2 But rather than the column incrementing I want to increment the row number so 1st cell is =A2 The cell on its right is =A3 how do i do that?

  Read the article

• excel automation edit existing chart

  - by user330737

  Hi Everyone, I need excel automation expert here. I have chart with x-axis contains label: Jan,Feb,Mar,Apr and y-axis contains label: 10,20,30,40. Chart type is Bar. Can anyone show me a csharp code how to change to Bar color to different color if the month is Mar? I hope you guy understand my question since I can't put the image on stackoverflow. thank you

  Read the article

• Export Excel in ruby on rails

  - by Small Wolf

  Hey guys! I want to export the page Info to Excel ,who can tell me how can i do this? thank you!

  Read the article

• Import numbers from an excel column using C#.

  - by LIX

  Hi. I have an Excel file with one column which is filled with numbers. I would like to be read the numbers from this column into an array in C#. How can I do that? Thank you all.

  Read the article

• Read/Write Excel Files Directly To/From Memory

  - by Corey O.

  Several people have asked, in a roundabout way, but I have yet to see a workable solution. Is there any way to open an excel file from directly memory (like a byte[]) ? Likewise is there a way to write a file directly to memory? I am looking for solutions that will not involve the hard disk or juggling temporary files. Thanks in advance for any suggestions.

  Read the article

• How to Validate Pasted Dates in Excel

  - by jimdrang

  I want to validate pasted dates to remove /'s and ensure the year is 4 digits and when users paste them in it overwrites my excel validation. So, If a user pastes 05/19/10 into a cell, I would like it to convert to 05192010 or at least give an error if this is not possible. I don't know enough VB to add sheet-wide code that does this and I'm not sure if it would work when users paste multiple cells at a time.

  Read the article

• Mapping between Excel and XML file - How to refresh from C#

  - by osteinme

  Hi Got an excel spread sheet where I specify mapping to an XML file. I'd like to open the spread sheet from C# and force refresh the cells mappped to the XML file. - How can I do that ? Any dll I need to reference ? Thanks Olivier

  Read the article

• Column No to Column Letter in Excel/VSTO using C#

  - by sukumar

  How to find column's name or header? For example if i select column 5 in excel means i want the result as "E". How to get the alphabet or letter corresponding to column no. Please help me with the code

  Read the article

• how to insert a jpeg image into an excel sheet

  - by Shiny

  Im able to generate tables with all required columns and with datas in excel sheet. now i want to insert image that is present in my bin.how can i achieve this. thanks in advance

  Read the article

• Import Excel spreadsheet columns into SQL Server database

  - by roy0911

  I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option. any easy code options? Thanks newbie

  Read the article

• Excel worksheet in Webbrowser component using c#.

  - by Rabin

  I have loaded an Excel worksheet inside a WebBrowser component. Now I need to do some calculation and insert the result of the calculation into a named cell in the active worksheet. Could someone please help me with this. Thank you.

  Read the article

• How to keep format within HTML converted to Excel

  - by pojomx

  Hello, I'm working with an HTML table, that contains numbers (formated) and when I export this to xls file (just change extension... hehe) I loss some of the formated data. Example: in html I have " 1,000.00 | 500.00 | 20.00 " and in excel it shows like: "1,000.00 | 500 | 20" I want it to know if it is possible to show the very same format as in html. THankyou :P

  Read the article

• Export Gridview with image to Excel - Problem

  - by Arny

  I have a Gridview in my ASP.NET C# Page. It has a couple of columns and also one image column. I can export the entire columns to an Excel file, but the image column is blank. By the way, I use the full path. Any Idea?

  Read the article

• Can you connect to sql server from Excel?

  - by AnonymousCow

  Hi, I need to create some reports from a sql server database for end users to view. Is it possible to hook into sql server from excel? Update The end user will only click on the file to view the reports, asking them to do more is too much to ask!

  Read the article

• Reading Excel file with C# - Choose sheet

  - by Dänu

  Hey Guys I'm reading an excel file with C# and OleDB (12.0). There I have to specify the select statement with the name of the sheet I wish to read ([Sheet1$]). this.dataAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); Is it possible to select the first sheet, no matter what name? Thank you.

  Read the article

• List of objects to Excel Spreadsheet?

  - by Max Fraser

  Anyone know of some code out there that does this already? I have a bunch of pages with data grids on them in an admin website they want to export them to Excel, was hoping someone had this written already - or if not I'll post mine when I am done.

  Read the article

• MS Excel connection with vb.net

  - by Noreen

  I have used the connection string below but I am getting an error when trying to create a table Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strFName + _ ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1""" Cannot modify the design of table 'tablename'. It is in a read-only database.

  Read the article

• Adding Date to Excel using Open XML

  - by Ant

  Hi, I would like to insert Date value to excel file using Open XML. Here is my code sample. cell.CellValue = new CellValue(value.ToString()); cell.DataType = new EnumValue<CellValues>(CellValues.Date);

  Read the article

• Updating data source on multiple pivot tables within Excel

  - by phrenetic

  Is there an easy way to update the data source for multiple pivot tables on a single Excel sheet at the same time? All of the pivot tables reference the same named range, but I need to create a second worksheet that has the same pivot tables, but accessing a different named range. Ideally I would like to be able to do some kind of search and replace operation (like you can do on formulae), rather than updating each individual pivot table by hand. Any suggestions?

  Read the article

• Import excel file into sql express 2008

  - by ck

  Hi, I've got some excel files, that were exported from tables in Access, and I want to import them into sql express 2005. I need a script that will convert nvarchar(255) columns to varchar(255) and preserve links, when importing the data into sql express. Thanks

  Read the article

• Cell color changing In Excel using C#

  - by Suryakavitha

  hi, I am using windows application for export data table to Excel...its working.. Now i want to give some color for particular text in the cell... How shall i do this? Anyone tell me the solution of this... Thanks in advance...

  Read the article

< Previous Page | 67 68 69 70 71 72 73 74 75 76 77 78  | Next Page >