[feat] add excel dataSource

bebee4java · bebee4java · commit e85794c9e3aa · 2020-11-09T11:58:29.000+08:00
diff --git a/engine/pom.xml b/engine/pom.xml
@@ -71,6 +71,12 @@
             <artifactId>scalatra-swagger_${scala.binary.version}</artifactId>
             <version>${scalatra.version}</version>
         </dependency>
+
+        <dependency>
+            <groupId>tech.ides</groupId>
+            <artifactId>ds-spark-excel-${spark.big.version}_${scala.binary.version}</artifactId>
+            <version>${project.version}</version>
+        </dependency>
     </dependencies>
 
 
diff --git a/external/ds-spark-excel/pom.xml b/external/ds-spark-excel/pom.xml
@@ -0,0 +1,35 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <parent>
+        <artifactId>DataLinked</artifactId>
+        <groupId>tech.ides</groupId>
+        <version>1.0.0</version>
+        <relativePath>../../pom.xml</relativePath>
+    </parent>
+    <modelVersion>4.0.0</modelVersion>
+
+    <artifactId>ds-spark-excel-${spark.big.version}_${scala.binary.version}</artifactId>
+
+    <dependencies>
+        <dependency>
+            <groupId>tech.ides</groupId>
+            <artifactId>ides-core-${spark.big.version}_${scala.binary.version}</artifactId>
+            <version>${project.version}</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.spark</groupId>
+            <artifactId>spark-sql_${scala.binary.version}</artifactId>
+            <version>${spark.version}</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>com.crealytics</groupId>
+            <artifactId>spark-excel_${scala.binary.version}</artifactId>
+            <version>0.13.5</version>
+        </dependency>
+    </dependencies>
+
+</project>
diff --git a/external/ds-spark-excel/src/main/java/tech/ides/external/datasource/excel/ExcelDataSource.scala b/external/ds-spark-excel/src/main/java/tech/ides/external/datasource/excel/ExcelDataSource.scala
@@ -0,0 +1,21 @@
+package tech.ides.external.datasource.excel
+
+import tech.ides.datasource.{BaseDataSource, BaseFileDataSource, DataSource}
+import tech.ides.datasource.DataSource.Method._
+
+/**
+  *
+  * Created by songgr on 2020/10/25.
+  */
+
+@DataSource(
+  types = Array(SOURCE, SINK),
+  name = "excel",
+  sinceVersion = "1.0.0"
+)
+class ExcelDataSource extends BaseFileDataSource {
+
+  override def fullFormat: String = "com.crealytics.spark.excel"
+
+  override def shortFormat: String = "excel"
+}
diff --git a/pom.xml b/pom.xml
@@ -35,6 +35,7 @@
         <module>dsl</module>
         <module>engine</module>
         <module>repl</module>
+        <module>external/ds-spark-excel</module>
     </modules>
 
 
