How To Export Table To Excel In Android App

This video shows the steps to create an Excel file in your Android App. It uses third party library (not available as in-built APIs) from org.apache.poi.

It hard-codes the file name and sheet name in the code. However, that can be taken as an input from the user.

For the content it takes the input from the user through an Edit Text widget. Though it uses a single line edit text but same can be done using a multi-line plain text (Edit text) user input.

It creates the file in the emulator's external storage. However, any location on the mobile device can be used to create the file.

I hope you like this video. For any questions, suggestions or appreciation please contact us at: https://programmerworld.co/contact/ or email at: programmerworld1990@gmail.com

Source Code

                package                com.programmerworld.excelfileapp;                  import                  android.Manifest;
                  import                  android.content.pm.PackageManager;
                  import                  android.os.Bundle;
                  import                  android.os.Environment;
                  import                  android.view.View;
                  import                  android.widget.EditText;
                                  import                  androidx.appcompat.app.AppCompatActivity;
                  import                  androidx.core.app.ActivityCompat;
                                  import                  org.apache.poi.hssf.usermodel.HSSFCell;
                  import                  org.apache.poi.hssf.usermodel.HSSFRow;
                  import                  org.apache.poi.hssf.usermodel.HSSFSheet;
                  import                  org.apache.poi.hssf.usermodel.HSSFWorkbook;
                                  import                  java.io.File;
                  import                  java.io.FileOutputStream;
                                  public class                  MainActivity                  extends                  AppCompatActivity {
                                  private                  EditText                  editTextExcel;
                  private                  File                  filePath                  =                  new                  File(Environment.getExternalStorageDirectory() +                  "/Demo.xls");
                                  @Override
                  protected void                  onCreate(Bundle savedInstanceState) {
                  super.onCreate(savedInstanceState);
                  setContentView(R.layout.                    activity_main                  );
                                  ActivityCompat.requestPermissions(this,                  new                  String[]{Manifest.permission.                    WRITE_EXTERNAL_STORAGE                  ,
                  Manifest.permission.                    READ_EXTERNAL_STORAGE                  }, PackageManager.                    PERMISSION_GRANTED                  );
                                  editTextExcel                  = findViewById(R.id.                    editText                  );
                  }
                                  public void                  buttonCreateExcel(View view){
                  HSSFWorkbook hssfWorkbook =                  new                  HSSFWorkbook();
                  HSSFSheet hssfSheet = hssfWorkbook.createSheet("Custom Sheet");
                                  HSSFRow hssfRow = hssfSheet.createRow(0);
                  HSSFCell hssfCell = hssfRow.createCell(0);
                                  hssfCell.setCellValue(editTextExcel.getText().toString());
                                  try                  {
                  if                  (!filePath.exists()){
                  filePath.createNewFile();
                  }
                                  FileOutputStream fileOutputStream=                  new                  FileOutputStream(filePath);
                  hssfWorkbook.write(fileOutputStream);
                                  if                  (fileOutputStream!=null){
                  fileOutputStream.flush();
                  fileOutputStream.close();
                  }
                  }                  catch                  (Exception e) {
                  e.printStackTrace();
                  }
                  }
}

apply                plugin:                'com.android.application'
                                                  
                android                {
                                                compileSdkVersion 29
                buildToolsVersion                "29.0.3"
                                                  
                                                defaultConfig                {
                                                applicationId                "com.programmerworld.excelfileapp"
                                                minSdkVersion 26
                targetSdkVersion 29
                versionCode 1
                versionName                "1.0"
                                                  
                                                testInstrumentationRunner                "androidx.test.runner.AndroidJUnitRunner"
                                                                }
                                                  
                                                buildTypes                {
                                                release                {
                                                minifyEnabled                false
                                                proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'),                'proguard-rules.pro'
                                                                }
                                                  }
                                }
                                                  
                dependencies                {
                                                implementation fileTree(dir:                "libs",                include: ["*.jar"])
                implementation                'androidx.appcompat:appcompat:1.2.0'
                                                implementation                'androidx.constraintlayout:constraintlayout:2.0.2'
                                                testImplementation                'junit:junit:4.12'
                                                androidTestImplementation                'androidx.test.ext:junit:1.1.2'
                                                androidTestImplementation                'androidx.test.espresso:espresso-core:3.3.0'
                                                  
                                                implementation                'org.apache.poi:poi:3.17'
                                                  
                                }

<? xml version ="1.0" encoding ="utf-8" ?>
<manifest xmlns: android ="http://schemas.android.com/apk/res/android"
package ="com.programmerworld.excelfileapp">

<uses-permission android :name ="android.permission.WRITE_EXTERNAL_STORAGE"/>
<uses-permission android :name ="android.permission.READ_EXTERNAL_STORAGE"/>

<application
android :allowBackup ="true"
android :icon ="@mipmap/ic_launcher"
android :label ="@string/app_name"
android :roundIcon ="@mipmap/ic_launcher_round"
android :supportsRtl ="true"
android :theme ="@style/AppTheme">
<activity android :name =".MainActivity">
<intent-filter>
<action android :name ="android.intent.action.MAIN" />

<category android :name ="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
</application>

</manifest>

<? xml version ="1.0" encoding ="utf-8" ?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns: android ="http://schemas.android.com/apk/res/android"
xmlns: app ="http://schemas.android.com/apk/res-auto"
xmlns: tools ="http://schemas.android.com/tools"
android :layout_width ="match_parent"
android :layout_height ="match_parent"
tools :context =".MainActivity">

<Button
android :id ="@+id/button"
android :layout_width ="wrap_content"
android :layout_height ="wrap_content"
android :layout_marginStart ="128dp"
android :layout_marginTop ="60dp"
android :onClick ="buttonCreateExcel"
android :text ="@string/create_excel"
app :layout_constraintStart_toStartOf ="parent"
app :layout_constraintTop_toTopOf ="parent" />

<EditText
android :id ="@+id/editText"
android :layout_width ="wrap_content"
android :layout_height ="wrap_content"
android :layout_marginStart ="78dp"
android :layout_marginTop ="57dp"
android :ems ="10"
android :hint ="@string/your_text_here"
android :inputType ="textPersonName"
app :layout_constraintStart_toStartOf ="parent"
app :layout_constraintTop_toBottomOf ="@+id/button"
android :autofillHints ="" />
</androidx.constraintlayout.widget.ConstraintLayout>

<resources>
                <string                                name                ="app_name">Excel File App</string>
                <string                                name                ="create_excel">Create Excel</string>
                <string                                name                ="your_text_here">Your text here ...</string>
</resources>

                // Top-level build file where you can add configuration options common to all sub-projects/modules.
                buildscript                {
                                                repositories                {
                                                google()
                jcenter()
                }
                                                dependencies                {
                                                classpath                "com.android.tools.build:gradle:4.0.1"
                                                  
                                                                // NOTE: Do not place your application dependencies here; they belong
                                                  // in the individual module build.gradle files
                                                                }
                                }
                                                  
                allprojects                {
                                                repositories                {
                                                google()
                jcenter()
                }
                                }
                                                  
                task clean(type: Delete)                {
                                                delete rootProject.buildDir
                }