1. Home
  2. Forum
  3. WPF
  4. Managing data with Excel

Managing data with Excel

Hi,

we would like to export data in excel and manage with a user interface some changes about format data and more.

Here below a link about our company and a video that explains what we want to aim  with XlslO component.

https://www.youtube.com/watch?v=hrLFl1BIvFk

Video is in italian but you can understand with the image what we want to do.

We would like to know if it is possible to reach same features with your component? 

I can also send you a pdf file that shows the result, but i don't see the possibility to attach a file in edit ticket.


Best regards

Gian Piero Truccolo


3 Replies
KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team April 28, 2020 11:59 AM UTC

Hi Gian, 

Greetings from Syncfusion. 

Please find the response for the queries below. 

Query 
Response 
we would like to export data in excel and manage with a user interface some changes about format data and more. 
Here below a link about our company and a video that explains what we want to aim  with XlslO component. 
Video is in italian but you can understand with the image what we want to do. 
We would like to know if it is possible to reach same features with your component?  
We have gone through and managed to get some information through subtitles from the video, though it is in Italian. What we understood is, similar to the document processing in the video, you are expecting to load Excel document into an Editor and edit it. 

Our Excel library (Syncfusion XlsIO), has all these functionalities from code.  

If you are expecting a Spreadsheet editor, you can check our Syncfusion Spreadsheet Control. 

  
I can also send you a pdf file that shows the result, but i don't see the possibility to attach a file in edit ticket. 
Currently we are allowing the file upload formats(.Zip, .rar & .7z) of a maximum 30MB size in the forums during creation and reply. We don’t allow the option to upload the files in edit option.  

Please zip your PDF file and compress below 30 MB and upload the file or if the size exceeds share the file using Google drive or drop box link of your convenience in your next update, if needed. 

Regards, 
Keerthi. 


GI Gian April 28, 2020 12:11 PM UTC

Here the example of the result we woul like to obtain, we will create by code behind a lot of inofrmation and structure.

Best regards
Gian Piero Truccolo

Attachment: Document_8988cda0.zip

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team April 29, 2020 11:19 AM UTC

Hi Gian, 

Thanks for the update. 

From the video we have understood that mainly you were trying to make following changes in the document. 

  1. Change or set font name, font size, font style and font color for a cell or range of cells.
  2. Change or set border style for a cell or range of cells.
  3. Resize the column width.
  4. Hide the column.
  5. Modify the cell value.
  6. Header style.
  7. Insert picture and modify its properties.
  8. Change or set font name, font size, font style and font color for page footer.

These requirements can be achieved through Syncfusion XlsIO. Please look into the following links or code snippets. 

S.No. 
Requirement 
Help Link / Code Snippet 
1. 
Change or set font name, font size, font style and font color for a cell or range of cells 
2. 
Change or set border style for a cell or range of cells 
3. 
Resize the column width 
The following link explains to resize single column. 

Please follow this below link to know about resizing a range of columns. 
4. 
Hide the column 
This can also be achieved by setting the Column Width as “0”. 

Code Snippet: 

//Hide the column by setting the column width as 0 
worksheet.SetColumnWidth(6, 0); 
 
5. 
Modify the cell value 
6. 
Header Style 
7. 
Insert picture and modify its properties 
8. 
Change or set font name, font size, font style and font color for page footer 
Kindly look into the following code snippet. 

Code Snippet: 

using (ExcelEngine excelEngine = new ExcelEngine()) 
{ 
  IApplication application = excelEngine.Excel; 
  application.DefaultVersion = ExcelVersion.Excel2013; 
  IWorkbook workbook = application.Workbooks.Create(1); 
  IWorksheet worksheet = workbook.Worksheets[0]; 
 
  //Adding values in worksheet 
  worksheet.Range["A1:A100"].Text = "HelloWorld"; 
 
  //Adding text with formatting to page footers 
  worksheet.PageSetup.LeftFooter = "&B &18 &K0000FF Left Footer"; 
  worksheet.PageSetup.CenterFooter = "&\"Arial,Bold\" &14 CenterHeader"; 
  worksheet.PageSetup.RightFooter = "&P &KFF0000 Right Footer"; 
 
  workbook.SaveAs("Output.xlsx"); 
} 
 

Kindly let us know if the above information is helpful. 

Regards, 
Keerthi. 


Loader.
Up arrow icon