-
Notifications
You must be signed in to change notification settings - Fork 80
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Feature request: export as excel format #430
Comments
Just came here to check for this feature as well. |
This is a huge work and will not be available before a long time. The data will be formatted: values are transformed into characters. I doubt we can reverse user-formats from R to Excel-formats, is it still wanted? For example, a column originally stored as numeric, will be stored in Excel as character; you will not be able to compute a mean on this column. |
I don’t think it’s necessary to transfer the format for excel. We just need a more flexible file to present the data. With excel file, we can easily handle really wide tables and use excel functions to review the data. It should be fine if we can’t do the computation in excel. If it’s really needed, user can manually edit the format in excel. |
For reference, I once wrote a proof of concept function to do just that. Convert a |
sorry @JanMarvin. We appreciate your suggestion to implement that feature, and we do have some existing drafts, for some features we will need to discuss with you. However, the implementation you provided doesn't quite meet our requirements (you can try it yourself, for example, with |
Hi @davidgohel, exactly, the list of what my proof-of-concept function can't do is still relatively long (it's above in the linked post), but nevertheless many of the less complex tables can already be converted to native xlsx variants along with the entire table layout. I had written the linked function at the time to have another use case for And with |
Here is my solution to this problem Package Link It's my first run on this problem from a standalone package perspective and there is much work to be done. Still, better than nothing I guess. Thanks to @JanMarvin for his inspirational work! |
@pteridin sorry for the very late answer. This looks excellent. I just had a quick try, it works very well. |
is it possible to export as excel format? sometimes, the table is too wide to fit into word document. if the table can be saved into excel format, we don't need to worry about the column width and also we can be flexible in review the data in the table.
The text was updated successfully, but these errors were encountered: