Free Support Forum - aspose.com

Working in Windows Forms

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");
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 http://www.aspose.com/Products/Aspose.Grid/ . It includes a winform control to display spreadsheets.