We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XML./HTML/PDF saveas

Thread ID:

Created:

Updated:

Platform:

Replies:

48227 Aug 23,2006 04:15 AM UTC Oct 9,2006 10:48 AM UTC Windows Forms 5
loading
Tags: XlsIO
David
Asked On August 23, 2006 04:15 AM UTC

Hi, First of all great product. I just brought your Enterprise Edition. The XLSIO makes it really easy to power through XLS files.

Ok, not the hard part. How can I get it to save my new Excel file as HTML, PDF, and XML in code?

Also, I tried the workbook.SaveAsXml(stream, ExcelXmlSaveType.MSExcel), but got the following exception:
System.ApplicationException was unhandled
Message="Cell dosn''t contain value"
Source="Syncfusion.XlsIO.Base"
StackTrace:
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.GetCellTypeValue(CellRecordCollection cells, Int32 iIndex, XmlSerializationCellType& type)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeData(XmlWriter writer, CellRecordCollection cells, Int32 iIndex)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeCell(XmlWriter writer, WorksheetImpl sheet, Int32 iRowIndex)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeRows(XmlWriter writer, WorksheetImpl sheet)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeTable(XmlWriter writer, WorksheetImpl sheet)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeWorksheet(XmlWriter writer, WorksheetImpl sheet)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeWorksheets(XmlWriter writer, IWorksheets worksheets)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.SerializeWorkbook(XmlWriter writer, IWorkbook book)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorkbookXmlSerializator.Serialize(XmlWriter writer, IWorkbook book)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAsXml(XmlWriter writer, ExcelXmlSaveType saveType)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAsXml(Stream stream, ExcelXmlSaveType saveType)
at hdcReportGenerator.HCRISReport.GenerateReport() in C:\Documents and Settings\dgodwin\My Documents\Visual Studio 2005\Projects\hdcReportGenerator\hdcReportGenerator\HCRISReport.cs:line 62
at hdcReportGenerator.ReportGenerator.ProcessReport(Int32 rpt_num) in C:\Documents and Settings\dgodwin\My Documents\Visual Studio 2005\Projects\hdcReportGenerator\hdcReportGenerator\ReportGenerator.cs:line 48
at hdcReportGenerator.Form1.btnProcess_Click(Object sender, EventArgs e) in C:\Documents and Settings\dgodwin\My Documents\Visual Studio 2005\Projects\hdcReportGenerator\hdcReportGenerator\Form1.cs:line 29
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at hdcReportGenerator.Program.Main() in C:\Documents and Settings\dgodwin\My Documents\Visual Studio 2005\Projects\hdcReportGenerator\hdcReportGenerator\Program.cs:line 17
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

Melba Winshia [Syncfusion]
Replied On August 23, 2006 01:19 PM UTC

i David,

Thank you for using Syncfusion Essential XlsIO.

1. I was not able to reproduce the problem while saving Excel file as XML. Here is the sample that I used for testing.

XML.zip


Please take a look at the sample above and let me know if you have any other questions.

2. Currently we do not provide support for Excel to PDF but it would be made available in a service pack release in about 2-3 weeks time frame. I will send you an update as soon as it is available

3. Regarding Excel to HTML, Currently it is not possible to convert Excel file to HTML.

Please let me know if you have any other questions.

Regards,
Melba

David
Replied On August 23, 2006 02:56 PM UTC

Hey Melba,

On crash - I will submit the file that is crashing via your ticket system tonight.

On PDF - is that a pretty solid release date? :)

On HTML - Once it is into PDF, can I save it to HTML from the PDF class?

I noticed in the Save as XML method the potential save types include another format besides Excel based XML (LDC I think?) - is there no way for me to use that stream to send it to your PDF product to do the conversion?


>i David,

Thank you for using Syncfusion Essential XlsIO.

1. I was not able to reproduce the problem while saving Excel file as XML. Here is the sample that I used for testing.

XML.zip


Please take a look at the sample above and let me know if you have any other questions.

2. Currently we do not provide support for Excel to PDF but it would be made available in a service pack release in about 2-3 weeks time frame. I will send you an update as soon as it is available

3. Regarding Excel to HTML, Currently it is not possible to convert Excel file to HTML.

Please let me know if you have any other questions.

Regards,
Melba

Melba Winshia [Syncfusion]
Replied On August 28, 2006 11:32 AM UTC

Hi David,

1) Excel to PDF functionality has been implemented internally and I can provide you with a preview version now. Can you please create a Direct-Trac incident regarding this so that I can provide you with a preview version? The conversion of Excel to PDF would take place in the following stages:

a) XlsIO reads the spreadsheet and serializes to an XML format.

workbook.SaveAsXml( "Sample.xml", ExcelXmlSaveType.DLS );

b) Its will be read by Essential PDF which produces the PDF file.

pdflDoc.OpenXml("Sample.xml");


2) On HTML - Currently it is not possible to save to HTML from the PDF class. Sorry for the inconvenience.

Please let me know if you have any other questions.

Regards,
Melba


Administrator [Syncfusion]
Replied On October 9, 2006 12:45 AM UTC

Is the save to PDF functions noe available in the lastest Sept 19 release?

Melba Winshia [Syncfusion]
Replied On October 9, 2006 10:48 AM UTC

Hi,

Excel To PDF functionality is not included as a part of 4.3 Release and it will be available only with 4.4 release. However we can provide with a preview of this functionality. Can you please create a Direct-Trac incident regarding this so that I can provide you with a preview version?

Please let me know if you have any other questions.

Thanks,
Melba

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;