Need an Excel-like grid in VB.NET
I am designing a program in VB.NET that can use an Excel-like grid. I want the grid to be able to handle merging and unmerging of cells. Suggestions? ...
excel
What are the (gotchas and) limitations when using POI to create Excel workbooks?
Just saw a crash as we exceeded 255 columns. Maybe this question should go directly to POI, but lets say I do not want to disturb them in their effort to further develop the increadibly useful API it already is. ;-) The limitations page is not increadibly detailed. So: What are your experience of actual limitations assuming the output s...
How do I get a list of folder names, which have Chinese names, into an excel sheet?
I know I can list the folders in the command line and copy it into a spreadsheet, but if the folder names are in Chinese, the names do not show up correctly. I guess the command prompt does not support Unicode? I am using an English Windows XP OS. ...
Help me find the reg-key which is preventing me from chaning excel macro security-level?
My automatic test-framework tests a bunch of Excel sheets required by our customers with the excel plugins that my team provides. In order to test the sheet I need to call some macros, this in turn requires macro security to be set to lowest on the testing servers. (In production macro security will be on). In particular I need to supres...
how to swap columns to rows view
I have following two columns of data in excel 2007: a 1 b 2 ... What I need to swap the view to: a b ... 1 2 ... I think there is way to do it in excel 2007. Is this possible? ...
How can I automate the creation of named references in Excel? I want the first field of every row to be my reference.
The first column of my spreadsheet is a unique key (data wise, nothing to do with excel). Another of my columns contains links to other rows (to that row's unique key). When I insert these hyperlinks, I need to point to "defined names" since the row order will change over time. I don't want to have to create the defined name every ...
Moving MS Excel data to a website via a web service.
I have an Excel spreadsheet template with data and a chart. I want to be able to publish (repeatably) the raw data to a web server using using a web service interface. I would like to do this with vanilla Excel--no add-ons or required ActiveX controls, etc. I am open to suggestions on the web service technology: REST, etc. Are there a...
How to parse an excel file in JavaScript?
I am trying to write a small web tool which takes an Excel file, parses the contents and then compares the data with another dataset. Can this be easily done in JavaScript? Is there a JavaScript library which does this? ...
How to Search a value in an Excel from .net application?
I have to search for a value over 5000 records from excel. What is the best approach to accomplish this in windows .net application? ...
Uniformly link contents of cells
I have a list of systems in a big group that are considered as one. They each have an 'Assessed' status, but I want to somehow link all those systems in the group together, so that if I change the assessment status in any of them, it will update to all those in the group. Is there a way of doing this, apart from assigning one as the 'mas...
Using Excel as front end to Access database (with VBA)
I am building a small application for a friend and they'd like to be able to use Excel as the front end. (the UI will basically be userforms in Excel). They have a bunch of data in Excel that they would like to be able to query but I do not want to use excel as a database as I don't think it is fit for that purpose and am considering usi...
How can I best use VBA in Access or Excel to test an ODBC connection?
Given a pre-configured ODBC System DSN, I'd like to write a function that gracefully tests that connection using VBA. Private Function TestConnection(ByVal dsnName As String) As Boolean ' What goes here?? ' End Function Edit: To clarify, the System DSNs are pointing to external SQL Server 2005 databases, with Windows NT authenti...
ASP: How to import data from a merged cell in Excel?
I need to import data from an excel file, but some field is a merged cell. How can I determine if a field is merged or not, and how many cells are merged together in that field? My code is like this: Dim Conn, DBPath ,Rs Set Conn = Server.CreateObject("ADODB.Connection") DBPath = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & Ser...
Is there a way to import an Excel worksheed file (ver 2.1) into SQL 2005 using SSIS?
I am receiving an Excel Worksheet file (ver 2.1) from one of our clients as part of a weekly date update. I am trying incorporate it into our automated update process, but I can't import the file in SSIS (or Sql Management Studio) as the oldest format I can process is Excel 3.0. Is there an update that will add support for this older f...
Limiting autoshape movement in Excel.
Hello, This is my first question here, so try not to be harsh. I am trying to create an excel sheet, which does the following: reads information from the database through the custom defined class using the read specifications, it creates autoshapes and puts them in first sheet Is there any way to get information when someone change...
Converting Excel to PDF with VS2008 and Office2007
I am trying to use Interop.Excell to save an Excel Workbook as a PDF file. I am using VS2008 and Office2007, and have downloaded and installed the SaveAsPDFandXPS.exe from Microsoft. This enabled me to save a Word document as a pdf using the following code: object frmt = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF; ...
How to create a list from beginning number and end number
I have a set of numbers: Column A: (A1)100,(A2)103,(A3)104,(A4)106 Column B: (B1)102,(B2)103,(B3)105,(B4)110 Column A is the beginning number and Column B is the end number. We need to create a list (on a separate cell) of numbers using the beginning number and end number using column A & B. E.g. based on the 1st set of data from Row...
desagree in excel
Hello, I need your help in this case: I have: 1 11 111 Cat1 a,b,c 2 22 222 Cat2 d 3 33 333 Cat3 e,f 4 44 444 Cat4 g,h,i and i want: 1 11 111 Cat1 a 1 11 111 Cat1 b 1 11 111 Cat1 c 2 22 222 Cat2 d 3 33 333 Cat3 e 3 33 333 Cat3 f 4 44...
How to zero fill a number inside of an Excel cell
How do you zero fill a number to 10 positions inside an excel spreadsheet? i.e. If cell A1 has 1234 how can cell A2 display 0000001234 (10 postions). ...
Smoothing formula for ChartType = xlXYScatterSmoothNoMarkers
Is there any reference materials to look up which specific smoothing formula is used for generating the lines of the ChartType = xlXYScatterSmoothNoMarkers? Is it natural cubic splines with knots at marker points? I am trying to code the formula in stata replicating this smooth line. Thanks. ...