convert a csv to excel without using xlsx package

Bil Bal

I want to convert a csv file to excel.

I found from the search in Internet that the best proposal it to use the library(xlsx) and use the write.xlsx(..) to write my dataframe to excel file.

However when I try to load and use the xlsx library and use it I receive the following:

Loading required package: rJava
Error : .onLoad failed in loadNamespace() for 'rJava', details:
  call: inDL(x, as.logical(local), as.logical(now), ...)
  error: unable to load shared object 'C:/Users/Ban/Documents/R/win-library/3.1/rJava/libs/x64/rJava.dll':
  LoadLibrary failure:  Could not find the specified mode. unit.

Is there any other way to convert the csv to excel or is there anyone faced the previous problem?

Dirk Eddelbuettel

A minimum of research on CRAN reveals a number of packages:

  • XLconnect needs Java
  • xlsx needs Java
  • openxlsx does NOT need Java but is younger and not as widely used
  • writexls uses Perl under the hood which most system have.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Convert excel file (xls or xlsx) to csv file

From Dev

Remove a worksheet in Excel using r package xlsx

From Dev

Convert XLSX to CSV correctly using python

From Dev

Convert .CSV to .XLSX using command line

From Dev

Convert .CSV to .XLSX using command line

From Dev

How to convert .xls to .csv using Powershell without Excel installed

From Dev

PowerShell - Convert CSV to XLSX

From Dev

Error in printing data.frame in excel using XLSX package in R

From Dev

Cannot write excel file using xlsx package in R

From Dev

Is there a neater way to convert a xlsx object to csv in Ruby using the podio gem

From Dev

Is there a neater way to convert a xlsx object to csv in Ruby using the podio gem

From Dev

How to convert xlsx file to csv file using shell script?

From Dev

How to convert .xlsm (macro enabled excel file) to .xlsx using Python?

From Dev

Converting XLSB to XLSX without using Microsoft.Interop.Excel

From Dev

Convert xls to xlsx without interop

From Dev

Shell script - convert Excel (xlsx) to CSV - remove blank space / tab space

From Dev

Convert a .xlsx (MS Excel) file to .csv on command line with semicolon separated fields

From Dev

How to convert excel workbook to pdf without using excel interop library?

From Dev

Convert .csv file for further manipulation using 'highfrequency' package on R

From Dev

Excel Cell Coloring using xlsx

From Dev

Convert *.xls or *.xlsx file to pipe separated .csv file using command line

From Dev

How to convert strings to numbers, when taking data from .csv to .xlsx, using openpyxl

From Dev

How to batch convert .csv to .xls/xlsx

From Dev

Code to convert .XLSX spreadsheet to CSV is not working as expected

From Dev

code for bulk CSV files in a directory to convert to xlsx

From Dev

VBS - Convert Tab Delimited CSV File to XLSX

From Dev

How can I import data from excel (xlsx, csv) to a HTML page using JavaScript?

From Dev

PHP Convert Excel File From ".xls" To ".xlsx"

From Dev

Error reading timestamps using "xlsx" package

Related Related

  1. 1

    Convert excel file (xls or xlsx) to csv file

  2. 2

    Remove a worksheet in Excel using r package xlsx

  3. 3

    Convert XLSX to CSV correctly using python

  4. 4

    Convert .CSV to .XLSX using command line

  5. 5

    Convert .CSV to .XLSX using command line

  6. 6

    How to convert .xls to .csv using Powershell without Excel installed

  7. 7

    PowerShell - Convert CSV to XLSX

  8. 8

    Error in printing data.frame in excel using XLSX package in R

  9. 9

    Cannot write excel file using xlsx package in R

  10. 10

    Is there a neater way to convert a xlsx object to csv in Ruby using the podio gem

  11. 11

    Is there a neater way to convert a xlsx object to csv in Ruby using the podio gem

  12. 12

    How to convert xlsx file to csv file using shell script?

  13. 13

    How to convert .xlsm (macro enabled excel file) to .xlsx using Python?

  14. 14

    Converting XLSB to XLSX without using Microsoft.Interop.Excel

  15. 15

    Convert xls to xlsx without interop

  16. 16

    Shell script - convert Excel (xlsx) to CSV - remove blank space / tab space

  17. 17

    Convert a .xlsx (MS Excel) file to .csv on command line with semicolon separated fields

  18. 18

    How to convert excel workbook to pdf without using excel interop library?

  19. 19

    Convert .csv file for further manipulation using 'highfrequency' package on R

  20. 20

    Excel Cell Coloring using xlsx

  21. 21

    Convert *.xls or *.xlsx file to pipe separated .csv file using command line

  22. 22

    How to convert strings to numbers, when taking data from .csv to .xlsx, using openpyxl

  23. 23

    How to batch convert .csv to .xls/xlsx

  24. 24

    Code to convert .XLSX spreadsheet to CSV is not working as expected

  25. 25

    code for bulk CSV files in a directory to convert to xlsx

  26. 26

    VBS - Convert Tab Delimited CSV File to XLSX

  27. 27

    How can I import data from excel (xlsx, csv) to a HTML page using JavaScript?

  28. 28

    PHP Convert Excel File From ".xls" To ".xlsx"

  29. 29

    Error reading timestamps using "xlsx" package

HotTag

Archive