Checkpoints on Excel
To use KANNA reports, you will need to upload your current Excel form data to KANNA and then configure the input items and other settings on KANNA.
In order to create a report template smoothly, please refer to the checklist below to confirm the Excel format and input method in advance.
*Please click here to see the form settings after uploading Excel to KANNA.
・Original Excel data → KANNA report screen
(2) Display settings for input data
(1) Cell merging
Cells cannot be merged in KANNA. If you wish to input data in a way that crosses over cells, please merge cells in Excel before uploading the data to KANNA.
・If you did not do cell merging in Excel
Excel file → Create format
・In case of cell merging in Excel
Excel file → Create report
(2) Display settings for input data
If you upload your data to KANNA with the display format set in Excel Home, it may be displayed differently on KANNA.
Therefore, before updating to KANNA, please make sure that the display setting in Excel is set to [Standard].
Also, please use the date function in the input items of the form template settings.
For details on how to set input items, please click here.
(e.g.) When you select [Short Date Format] in Excel and enter a date (first page), the date is displayed differently in KANNA (second page).
(3) Font size
If font sizes differ within the same row, the row width will be changed to match the larger font size.
(e.g.) In Excel (left image), if the font size of row 8, column B is "14" and the font size of the blank cell in the red frame is "20" and uploaded to KANNA, the row width will be changed to match the larger font size "20" when the form is created (right image).
(4) Font Positioning
If you set text position settings such as "Wrap" and "Align Right" in Excel and upload the file to KANNA, the same settings will be applied on KANNA.
The settings cannot be changed in KANNA, so please check the text position settings in Excel.
(e.g.) When a certain number of characters are entered in a cell with the "Wrap" setting, a new line is inserted and the entire text is displayed.
If the number of characters to be entered in the relevant cell is large, the "Wrap" setting is recommended.
*Please note that if the corresponding cell is wrapped to a line break, another cell on the same line will also be wrapped to a line break. (2nd page)
(5) Text color/bold
As with cell merging, formatting cannot be edited on KANNA. Therefore, if you want to set bold or colored text, please make sure that the text is set correctly in Excel.
Cells cannot be colored.
(6) Cell width/height
If the width or length of the cell is too large, or the font size of the text is too large, the text may not be displayed in its entirety.
(e.g.) If the font size of "What happened:" is too large for a cell, only up to "happened" will be displayed when creating a report in KANNA (second page).
(7) Hide cell settings
Cells that are hidden in Excel will not be displayed in KANNA.
(e.g.) If you upload to KANNA with column E hidden (right side of Excel screen), it will not be displayed in KANNA either (KANNA screen).
・Excel Screen
・KANNA Screen
Column E is not displayed
(8) Object
Unintended shapes or lines may appear when uploading forms. (1st image)
In this case, the object may have been set in the original Excel data.
This can be corrected by editing the original Excel data.
・How to check/correct
1. Open the original Excel data and click [Review].
2. Click [Accessibility Check]
3. Click【Object】displayed in【Error】and delete it.
Click on 【Object】 to select the target Object, and then delete it by pressing the "Back space" key.
4. Completion
Please upload the file to KANNA again.
(9) Graphic
Excel [Graphic] may not be displayed properly on the KANNA Report.
If you output Excel from KANNA Report, it will be displayed correctly in Excel.
Therefore, if you want to display the data correctly on the KANNA Report, we recommend that you input the data directly into the cells without using figures.
(e.g.) : Pattern with company information and company logo in a graphic
First image : Excel original data screen
Second image : KANNA report screen