Xross Mode / Runtime Settings / Export to Excel
In This Topic
    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
    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