Adding a full year calendar to a single slide

[Edward Williams]

Hello,

I am creating a PowerPoint file. On one of the slides, there needs to be a full year calendar. The current application that is using the COM Objects uses Excel to create the full calendar and then copies it and pastes it into the slide as an image that can be resized accordingly (see below). As seen below, we are only interested in the days of the week Monday through Friday.

Now, working with Syncfusion Presentation, I am trying to find a way to recreate this same type of result. My first thought was to build a set of tables (one for each month). However, I could not get the total size of a month to be small enough to make them all fit and have the numbers in the cells still readable.

So, I was wondering if you might have a better solution. Any ideas would be appreciated.

[Edward Williams]

Not sure if the pasted image is showing properly. I have attached a zip file with the image of the full slide.

Attachment: Total_Absence_Calendar_db2f5ba1.zip

[Lokesh Baskar]

Hi Edward,

Yes, using the Syncfusion presentation you can achieve your requirement. Please refer to the below UG documentation task to know about working with tables in presentation.
https://help.syncfusion.com/file-formats/presentation/working-with-tables

Could you please share the sample application used at your end to create the full calendar using the excel and then copy and paste it in slides.  

And also could you please share with us the expected output document (manually modified using Microsoft PowerPoint application). Thereby we will check and update the sample application using the Syncfusion presentation library at the earliest. 

Regards, 

Lokesh B 

[Edward Williams]

Unfortunately, it looks like I may have hit a limit with using tables to accomplish what I am after. The size of the slides are using the Standard Sizing (4:3). What I am doing currently is I am placing three months in one "column" across three "rows". These calendars will need to have the day of the month as well as a number representing the absent students on any given day. Due to the size of some school districts, this number of students can get quite large. So, I have structured each day of a month to be essentially four cells in the table. The upper left cell of the four is used for the day of the month. Then, the two lower cells are merged to house the number of students. so cut down on the size of the calendar, I exclude Saturdays and Sundays, leaving up to five days in a week. Now, comes the tricky part. Due to how the weeks align in a given month, there could be up to six weeks in any given month. This results in tables that have to be up to 12 x 10. The smallest I can get any one cell is 0.2" x 0.23". However, this takes up quite a bit of room and will certainly not be able to house all the months of a given year.

The process that I use now, which is using the COM objects for Office, uses Excel to create the entire year calendar. Then it takes this chart and copies it, pasting it into the slide as an image. This image can then be sized to fit particular dimensions. However, it seems that the tables sizes are not as flexible as I need.

I will look into the possibility of trimming out the "6th" week to reduce the height of the resulting month calendar. But if you have any other suggestions, I am open.

[Lokesh Baskar]

Hi Edward,

Regarding creating the table using the Syncfusion presentation library.

From the given details, we have not gotten the complete details about your requirement. So, could you please share us the sample which you tried using presentation or expected output document (edited manually). Thereby, we will check and provide you the sample using Presentation.

Regarding “The process that I use now, which is using the COM objects for Office, uses Excel to create the entire year calendar. Then it takes this chart and copies it, pasting it into the slide as an image. This image can then be sized to fit particular dimensions. However, it seems that the tables sizes are not as flexible as I need”
You cannot insert an image directly into the table cell using presentation.
We can do it another way by setting the Picture Fill in the table cell. We have prepared the sample application to insert picture fill into the table cell. Please refer to the sample in the below attachment.

Regards, 

Lokesh B 

Attachment: presentation_sample_2e4ab6e7.zip

[Edward Williams]

Thanks, but I am not pasting an image into a table cell. The original process creates the entire year calendar in Excel and then copies that and pastes it on the slide as an image. No table involved. Now, that I am using Syncfusion, this is not an option.

However, I think I am getting it figured out. There is a whole issue with the cell margins that was killing my ability to make the table cells small enough. But by setting the cell margins to 0 and the font size to 7, it looks like I can achieve what I'm looking for. I have broken each month into it's own separate table. A few more tweaks, and I just might have it.

Thanks for you responses and suggestions.