[excel] Forum Topics

Firstly, im not sure if this is the correct location for a VBA question? Please move if necassary. This is my first major project using VBA - Ive previosuly used vb.net quite alot, and still adjusting to understand both, and the differences. My question is: I have a folder with …

Hi everyone I currently have a program that imports data from an excel sheet that is already made. The data also creates a chart. I need the chart to load into the program and I think that the only way to do that is by importing it into a picturebox. …

I am trying to change the order of how my excel worksheets tab appear in my workbook. I have a .net app that parses and pulls data from sql and exports it to excel. Currently it spits out 5 tabs and the Summary tab is in the middle. I want …

Recently, I meet a problem that I need to insert header and footer in excel with C#, I use the following code: Worksheet sheet = workbook.Worksheets[0]; sheet.PageSetup.FullHeaderString = "E-iceblue"; sheet.PageSetup.IsPrintHeadings = true; sheet.Visibility = WorksheetVisibility.Visible; sheet.PageSetup.LeftFooter = "everlasting"; But when I launch it, the header and footer do not appear …

i created a report which exports to excel. it exports just fine. what i want to do now is merge the consecutive cells in a column which have the same values. how do i do this? please help me. this is code that generates the excel body: Protected Sub generateExcelBody(ByVal …

Hi guys Basically im making a application that holds certain data that is read into the app, those readings are sent to excel and make a grapgh, which can be viewed on to the same page in the application. Each different sections data is put on to a seperate "sheet" …

Okay, I am 50% toward having this figured out, but there are a couple of concepts that are new to me here and it is throwing me for a loop. I am reading an Excel file into VB.NET. There are 4 columns containing dollar figures of varying amounts. Here is …

dear friends following is the code for export data from data grid to excel .. problem which i m facing that .. i could not export the last coloum values.. kindly give sulotion.. `Inline Code Example Here` Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim …

Hey guys, i need to know if i can find a FREE excel like datagrid that will allow inline editing and has drop down boxes for some fields. Also filed may be able to collect their default data from a session variable. I have tried this: [url]http://azgtech.wordpress.com/2010/08/01/jqgrid-php-datagrid/[/url] Thanks, Marais

hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks

Hi everyone I have an excel sheet and in this sheet i have a column with plain text data in list.. the data is just like (sample) 123131 | 564656311 85463 | 965132 3257| 93154911235 I need to create two columns from this column.. 1. i need to convert data …

I am currently running Windows 7 Home Premium SP1, AMD FX-6100 Six-Core Processor 3.3 GHz, 8.00 GB RAM, 64-bit OS. My problem occurs while running Excel and Word 2007. However, all systems with 2007 or 2010 office have the same issues in our office.(Some are XP, Windows 7 and one …

Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the …

Hello everyone. I have the following issue: I have a Windows XP computer with excel 2003 installed. we use several automation robots using excel. everything works fine, files area created and all that. but we have a problem. for some reason the document recovery pane of excel is getting filled …

Hello everyone, i have the following problem and I come here looking for some advice. I am using c#, but i have a dll that creates the excel file in Visual Basic. i have a datagridview and the information there is exported to excel file. No problem there. the problems …

I have searched and nothing that I have found hits directly on what I am looking for (or maybe my searches have not hit on the combo of words). In C# I have created an Excel sheet, using Interop.Excel, in which I insert some data and create a chart. This …

Hi there. I have a few hundred/thousand macro enabled spreadsheets that need to be uploaded to a database. The spreadsheets have a button that copies the data over to the database and it prompts the user for a username and password in order to do so (same for all files). …

Hi, I need to create an html page to export some information. Currently, by using java, i've exported information to excel. But now, I need to export the information in HTML page using java.Is there any APIs I can use? Thanks.

Hi there, I was trying to edit a excel document and save under different name and my coding for this is as follows. [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Open Dim MyExcel As New Excel.Application MyExcel.Workbooks.Open("C:\Test\WalkAir.xlsx") 'Extract MyExcel.Sheets("sheet1").Activate() MyExcel.Range("A99").Activate() MyExcel.ActiveCell.Value = TextBox1.Text MyExcel.SaveAs("C:\Test\alkAir.xlsx") MyExcel.Workbooks.Close() …

Hi, I have attached a printscreen version of my excel template here, Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database. Thanks

[CODE]Imports System.Data.SqlClient Imports System.Data.OleDb.OleDbConnection Imports System.Data.OleDb.OleDbCommand Imports System.Data Partial Class Main Inherits System.Web.UI.Page Public strSQL As String Public strConn As String = ConfigurationSettings.AppSettings("strConn") Dim objConn As SqlConnection Dim objAdap As SqlDataAdapter Dim objCmd As SqlCommand Dim objReader As SqlDataReader Private Sub cbfGenerateTable() Try objConn = New SqlConnection(strConn) strSQL = "SELECT …

Hi, I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. how can I create a sample template using vb.net code? Thanks

Hi, I just have this program that needs to create a downloadable template for the excel file that will be used later in my program, now I have this templates in my server and I think that i'll just import this file first and then put it in the data …

Hi, I have this program that uses OLEDB connection to import excel file to data table then use it in other functions. Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to …

Hi, I have this code that will import the excel sheet to the datatable then inserts it in the database, but I have this problem. I have set the HDR to yes so that the first row will be considered as its header, but the problem now is that if …

please find attached screen prints on how my data looks on XL sheet (as-is). With the help of Macros, I need to cut every 4 columns and need to paste it in a different XL TAB. I have attached another Attachment which gives how my data should look once Macro …

Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection …

I have an application that needs to know how many excel rows are in a worksheet before they are imported into my application. at the moment I am asking the end user to enter this into a text box, but would like my application to do this can anyone suggest …

I have this question. I have already imported all the excel data in the datatable, but now I want them stored in a 2 dimensional array, meaning I want to have this kind of thing in the array, something like array[x][y], where x is the row and y is the …

Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the …