judir
January 20, 2006, 8:50am
1
I am trying to evaluate Apose for use in vb.net windows forms. I am working in VS2003 I am trying to do a simple "Hello World" example and cannot get anything to display or save, although no exceptions are thrown and a blank form displays. What am I doing wrong? (code is shown below). Also my current environment does not allow web development, so I cannot access the demos. Do you have any demos specifically for Windows Forms? Thank you for your assistance. I entered the following code: Imports Aspose.Excel Public Class Form1 Inherits System.Windows.Forms.Form [generated code] Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Try Dim ex1 As New Excel Dim Cell1 As Cell = ex1.Worksheets(0).Cells("A1") ex1.Save("C:\SSEval\AposeSS\blank.xls") Cell1.PutValue("Hello World!") ex1.Save("C:\SSEval\AposeSS\HelloWorld.xls", FileFormatType.Default) Catch ex As Exception Trace.Write(ex) End Try End Sub End Class
We will include winform demos in future release.
You code is fine and the generate files are saved on your local disk. You can see the file on your specified folders.
Or you can add following code to show your generated file:
ex1.Save("C:\SSEval\AposeSS\blank.xls") Process.Start("C:\SSEval\AposeSS\blank.xls") Cell1.PutValue("Hello World!") ex1.Save("C:\SSEval\AposeSS\HelloWorld.xls", FileFormatType.Default) Process.Start("C:\SSEval\AposeSS\HelloWorld.xls");
judir
January 23, 2006, 2:13pm
3
Thank you for your patience, but I guess I am not seeing the whole picture here. I am trying to "see" the grid within my form at runtime. Adding this code: Process.Start("C:\SSEval\AposeSS\HelloWorld.xls") opens the file that was saved to disk in Excel, not on my form. Also the Hello World that I expected to see in cell A1 is not present. What do I need to do to see a spreadsheet within my form? Why in the above example is "Hello World" not present when opened in Excel? Maybe I should ask a general capabilities question first. Our application would allow us to display a spreadsheet grid on a Windows form, allow the user to enter data (directly or by pasting via Windows Clipboard) and then save this data as an Excel spreadsheet. Is this possible with Aspose? Also please send some Windows Forms demos.
After calling Excel.Save method, data in this Excel object is reset. So "Hello World" doesn't occur on the second file.
To show your spreadsheet on windows form, please try Aspose.Grid at
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &...
It includes a winform control to display spreadsheets.