ExcelAdd-In
The Sxcoal Excel Add-In provides real-time data access via Open API, eliminating frequent webpage logins and enabling efficient data updates through template creation. Users can access comprehensive industry data, including prices, indexes and statistics for coal, coke, power, metallurgy, building materials, chemicals and other industries.
Instant Data Access: Retrieve real-time data directly into Excel via Open API.
Simplified Data Management: Build templates for automated, timely updates.
Extensive Industry Data: Access a wide range of Sxcoal's online and offline data.
Download Install Pack
For more details, please contact us at +86 351 7219 322.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

// Imports

import mongoose, { Schema } from 'mongoose'

 

// Collection name

export const collection = 'Product'|

 

// Schema

const schema = new Schema({

name: {

type: String,

required: true

},

 

description: {

type: String

}

}, {timestamps: true})

 

// Model

export default mongoose.model(collection, schema, collection)// Imports

import mongoose, { Schema } from 'mongoose'

 

// Collection name

export const collection = 'Product'|

 

// Schema

const schema = new Schema({

name: {

type: String,

required: true

},

 

description: {

type: String

}

}, {timestamps: true})

 

// Model

export default mongoose.model(collection, schema, collection)// Imports

import mongoose, { Schema } from 'mongoose'

 

// Collection name

export const collection = 'Product'|

 

// Schema

const schema = new Schema({

name: {

type: String,

required: true

},

 

description: {

type: String

}

}, {timestamps: true})

 

// Model

export default mongoose.model(collection, schema, collection)

// Imports

import mongoose, { Schema } from 'mongoose'

 

// Collection name

export const collection = 'Product'|

 

// Schema

const schema = new Schema({

name: {

type: String,

required: true

},

 

description: {

type: String

}

}, {timestamps: true})

 

// Model

export default mongoose.model(collection, schema, collection)// Imports

import mongoose, { Schema } from 'mongoose'

 

// Collection name

 

 

Smart and convenient
A1
1
A
B
C
D
E
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22