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
SxcoalAPI
The Sxcoal Application Programming Interface (API) provides direct access to our data. It has been developed to meet enterprise clients' growing demand for more convenient data integration and utilization.
With Sxcoal API, you can access all the data on our website, including the pricing data, such as the CCI indexes, prices of thermal coal, coking coal, anthracite, met coke and freight rates for inland truck transport and coastal and international vessel shipment, and the statistical data, such as coal production, supply, demand, import/export, stocks and transport, key data of power, steel and other industries, international markets data, and Fenwei exclusive monitoring data for coal and coke production, sales and stocks.
You can obtain the data id and datasets corresponding to your subscriptions, mainly via JSON or EXCEL formats.
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