Date
1 - 6 of 6
Handling EXCEL-Files with DevExpress
|
Hi all,
does anyone have experience using the DevExpress spreadsheet api to trade EXCEL files?
An example?
Many Thanks Friedrich |
|
|
|
Adrian Wick
Hi Friedrich.
What do you mean by "to trade EXCEL files?" Do you want to display "excel" in magic for with devexpress? Regards A |
|
|
|
Hi Adrian,
thank you very much for your answer! Displaying EXCEL Files with devexpress would be nice too, but it is easy to do with the .NET System. No I want to create 'more complex' EXCEL-Files with multiple Tabs, formating Cells,..... In the meantime I bought the "DevExpress Office File API" which offers this capabilities and I build a first prototype, which looks good. I think i will go further with this. Regards Friedrich |
|
|
|
You mean something like this?
 https://i.ibb.co/1M3mShh/2023-01-27-19-07-26-Clipboard.png Regards, A |
|
|
|
On Fri, Jan 27, 2023 at 07:06 PM, Adrian Wick wrote:
https://i.ibb.co/1M3mShh/2023-01-27-19-07-26-Clipboard.pngYes |
|
|
|
Adrian Wick
I am not sure if Office File Api supports this. This is done with devexpress winforms.
You need two object types: A variable dotnet with DevExpress.XtraSpreadsheet.SpreadsheetControl (for displaying excel) B variable dotnet with DevExpress.XtraBars.Ribbon.RibbonControl (for the ribbon control) (It has been over a year since I dug into devexpress. There might be also some other .dlls you have to include ...) 1. Put SpreadSheetControl on the form. 2. In task prefix update B variable with A.CreateRibbon() 3. Evaluate Expression A.FindForm().Controls.Add(B) 4. A.LoadDocument('something.xlsx') Regards A |
|
|