excel

I am trying to import some data from excel. i am using visual studio 2008 .net 3.5, on win xp sp3 the data that is being imported form excel is being edited somewhere in the import. i am sure it is somthing todo with the olddb connection. the data is coming out like this 6.05708e+008 the...

Hey i need a program that will read data from 1 column in an excel spreadsheet and then find a specific character in each record then copy all text before that character into the column next to it. for example if you had an email address like johnsmith@hotmail.com in A1 it would take all the...

Hi all I made a project of autmation of Excel by adding reference type liberary of MS Excel and I cauld read and write to the cells but I can't get or set the hyperlink of the cells How can I access the hyperlinks either to a website or to a file on local machine? also if possible, can any...

My apologies up front if I am posting in the wrong forum ... I have a vb.net app that uses excel via ActiveX. If the user kills Excel instead of returning to the app and letting it do it, I get an unhandled exception popup for the exception RPC_E_DISCONNECTED when the app tries to close the...

How to insert barcode images into a Microsoft Excel worksheet using C# or VB.NET and Barcode Professional for .NET Technologies used - Neodynamic Barcode Professional 2.5 for .NET Windows Forms or greater - Microsoft .NET Framework 1.x or greater - Microsoft Visual Studio .NET or greater -...

Hello everyone! Please bare with me because I'm new to vb.net .I do have problem, I cannot save data from datagrid to excel. I use inputbox so user can input data to datagrid. Then the user can click the button to save it to excel. Can someone please show me some code on how to create that? Thanks!

Hi, I'm providing a link button in my page(which contains a datagrid) so that when the user clicks on it they will be able to see the contents of the datagrid in a separate excel file.I provide the user with the option of attaching documents while they use my application.I would want that...

What’s new in this release? In past, you have had to use Aspose.Cells and Aspose.Pdf for converting Excel files to PDF but now it is possible by using current version 4.7.0 of Aspose.Cells only. This version further supports: Inserting a WAV file as OLE object, reading or writing check boxes in...

i am writing a program that will take input on: customer name part number part info process to make part (array) material requirements compare to seperate excel workbook pages on: raw material costs customer markup and discounts and output all inputs as well as price estimates to a third page...

Hi there I am busy using an existing Excel workbook to generate quotes, but at the moment the path to the workbook is absolutely referenced. Dim wb As Excel.Workbook = excel.Workbooks.Open("C:\Users\Bob\Documents\Visual Studio 2008\Projects\Quoter\bin\Debug\Quote.xls") How do I use relative...

Hi, I have been loking at this for a while now and haven't really found anything helpful searching on Google, so I thought I'd post my query here. I have created a form that takes data held in an acces database, and then creates an excel chart, saves it as an image and displays it on my form...

This technical tip shows how to convert an Excel XLS file to PDF even if it contains any images or charts within it. You will be using Aspose.Cells and Aspose.Pdf libraries for XLS2PDF conversion. Please also make sure to save your Aspose.Pdf XML file on disk, not in a stream because Aspose.Pdf...

What’s new in this release? The previous version of Aspose.Cells allowed you to convert Excel XLS to HTML file and converting worksheet to image. However the latest version supports to read and write XLTM and XLMX files. Many new features like: Exporting Pivot Table to Excel 2007 file and...

Hi I am a vb.NET hobbyist from India. I am trying to design a data entry application for my company to deal with customer information. I am able to read and write data from and to a excel database using my vb.NET application. Every row in the database file contains details about a customer. I...

Aspose publishes January 2009 Newsletter for .NET & Java programmers by highlighting the newly supported features by Aspose.Slides for Reporting Services, Aspose.Total, Aspose.Words, Aspose.Pdf.Kit, Aspose.BarCode, Aspose.Workflow, Aspose.Cells, Aspose.Words for Reporting Services, Aspose.Form...

Hello, I am really new to vb.net and programming in general. I am wondering if someone can show me how to do this. I have a text file called for example... mytestfile.txt it looks like this: NUMBER....NAME.............................SECOND NAME ======= ====================...

I am experienced in developing vba code within Excel, but I am a novice with vb.net. I have created a new "Excel 2007 Workbook" project using the installed template in VS2008. Apart from a few initial config difficulties, I have succeeded in setting up a new workbook, and have developed quite a...

Hi guys Still around importing Excel Files to DataGridView. Since my main problem was to keep color formating, I got to use the following function: Private Sub LoadXLSFile() Dim xlApp As New Microsoft.Office.Interop.Excel.Application...

Hi there I am developing a small app to help manage huge Excel worksheets. These worksheets have multiple cells colored within. I am loading the worksheets to a DataGridView as show below but I want to keep the cell colors. Any ideias on how to achieve this? Would help if I didn't have to cycle...

Hi there, I have been trying to get this workin for last few days and have searched all over net with no solution. I want a gridview with 2 columns, one is a dropdown box with the values of the Excel schema, the other is just a textbox with each row having a different item of the sql table...