C#实现几十万级数据导出Excel及Excel各种操作实例代码详解(转)

 

本篇文章主要介绍了C#实现几十万级数据导出Excel及Excel各种操作实例，这里整理了详细的代码,有需要的小伙伴可以参考下。
先上导出代码



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

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

///

    /// 导出速度最快

    ///

    /// <列名，数据>

    ///

    ///

    public bool NewExport(List list, string filepath)

    {

      bool bSuccess = true;

      Microsoft.Office.Interop.Excel.Application appexcel = new Microsoft.Office.Interop.Excel.Application();

      System.Reflection.Missing miss = System.Reflection.Missing.Value;

      appexcel = new Microsoft.Office.Interop.Excel.Application();

      Microsoft.Office.Interop.Excel.Workbook workbookdata = null;

      Microsoft.Office.Interop.Excel.Worksheet worksheetdata = null;

      Microsoft.Office.Interop.Excel.Range rangedata;

  

      workbookdata = appexcel.Workbooks.Add();

  

      //设置对象不可见

      appexcel.Visible = false;

      appexcel.DisplayAlerts = false;

      try

      {

        foreach (var lv in list)

        {

          var keys = lv.Key as List;

          var values = lv.Value as List<ilist

https://www.php.cn/csharp-article-355255.html