将CSV文件转换为Android Java中的XLSX [Android 6]
我正在通过从SQLite表中获取数据来创建CSV文件。我想将CSV文件转换为XLSX格式,以通过蓝牙共享。我仅限于Android 6。
我尝试过:
- Apache POI(Min SDK Android 8)
- GroupDocs(Heap Memory耗尽)
- ASPOSE ASPOSE
3rd One似乎没有Android 6,但会出现错误。
这是代码段:
生成Excel:
genrateExcel.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String file = Environment.getExternalStorageDirectory().getAbsolutePath() + "/Download/";
LoadOptions loadOptions = new LoadOptions(FileFormatType.CSV);
Workbook workbook = null;
try {
workbook = new Workbook(file + "SensorData.csv", loadOptions);
} catch (Exception e) {
e.printStackTrace();
}
try {
workbook.save(file + "CSVtoExcel.xlsx" , SaveFormat.XLSX);
} catch (Exception e) {
e.printStackTrace();
}
}
});
我的CSV文件是生成的,并保存在下载文件夹中,用户可见。
我在行上遇到了一个错误:
workbook = new Workbook(file + "SensorData.csv", loadOptions);
这是LogCat文件的链接: logcat链接
它说某些类是缺少的:
java.lang.NoClassDefFoundError: Failed resolution of: Ljava/awt/SystemColor;
这:
java.lang.ClassNotFoundException: Didn't find class "java.awt.SystemColor"
我已经搜索了整个Internet进行转换,但没有找到适合我需求的任何东西。我的最后选择是使用aspose,但它显示了一些错误,这些错误在谷歌搜索时也找不到。事先感谢所有将提供帮助的人。
I am creating a csv file by taking data from SQLite table. I want to convert the csv file to xlsx format for it to be shared by bluetooth. I am limited to android 6.
I have tried:
- Apache POI (Min SDK Android 8)
- GroupDocs (Heap Memory Runs out)
- Aspose
The 3rd one seems to work without android 6 but it gives error.
Here are the code snippets:
Generate Excel:
genrateExcel.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String file = Environment.getExternalStorageDirectory().getAbsolutePath() + "/Download/";
LoadOptions loadOptions = new LoadOptions(FileFormatType.CSV);
Workbook workbook = null;
try {
workbook = new Workbook(file + "SensorData.csv", loadOptions);
} catch (Exception e) {
e.printStackTrace();
}
try {
workbook.save(file + "CSVtoExcel.xlsx" , SaveFormat.XLSX);
} catch (Exception e) {
e.printStackTrace();
}
}
});
My CSV file is generated and is being saved in the Downloads Folder and is visible to user.
I am getting an error on the line:
workbook = new Workbook(file + "SensorData.csv", loadOptions);
Here is the link to the logcat file:
Logcat Link
It says some class is missing:
java.lang.NoClassDefFoundError: Failed resolution of: Ljava/awt/SystemColor;
and this:
java.lang.ClassNotFoundException: Didn't find class "java.awt.SystemColor"
I have searched whole internet for the conversion and didn't find any suitable to my needs.My last option is using Aspose but it shows some errors which also cannot be found upon Googling. Thanks in advance to all the people who will be helping.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论