Export to Excel
In This Topic
Click Export at runtime to output data displayed in the view to an Excel file. The table shown below describes items that can be output.
Output Items
The following table shows items that can/can't be output. ✔: can be output; x: can't be output.
| Operation | Description |
|---|---|
| Cell value | ✔ |
| Format (display format) | ✔ |
| Shrink to display the whole | ✔ |
| Conditional format | ✔ |
| Filter | × |
| Cell merging | ✔ |
| Background and character colors | ✔ |
| Font | ✔ |
| Text alignment | ✔ |
| Text control | × |
| Row height | ✔ |
| Column width | ✔ |
- krewSheet doesn't limit the length of formula or string that is used in the formula. If these lengths have been set exceeding the limit specified by Excel, the exported Excel file can't be properly opened.
- The format that isn't supported by Excel (e.g., indent) won't exported to an Excel file.
- If the rules having the condition of numeric values is applied to fields other than numeric values (e.g., Text) in the conditional formatting such as an icon set, it doesn't work properly in the exported Excel file.
- Regarding the format of days such as "ddd" or "aaa," its display will change on krewSheet according to the language setting of the Kintone account (like English: Wed, Japanese: 水), though in Excel, "ddd" is displayed as Wed while “aaa” is 水.If you don't want to change the display according to the Kintone language setting, add locale ID to make it something like "[$-ja-JP]m/d(aaa)."
See Also