如何使用sharepoint online将列表保存为csv文件

Question

我随身带着SharePoint列表。我想在不使用第三方工具或powershell的情况下将该列表保存在.csv中(因为在我的情况下，它不会处理数据库)，我如何使用SharePoint online -office 365来实现此目的

Answer 1

转到您的库Excel库选项卡->导出到->

Answer 2

这是代码是导出文件的.csv格式。

<?php
    //Database connection starts
    ob_start();
    session_start();
    include_once('includes/config.php');
    //Database connection ends

    //export .csv file starts here
    $filename = "testing-exports.csv";

    header("Content-type: text/csv");
    header("Content-Disposition: attachment; filename=$filename");
    header("Pragma: no-cache");
    header("Expires: 0");

    $insquery = "SELECT username FROM r_institution where status=1";
    $insresults = $conn->query($insquery);
    foreach ($insresults as $rs) {
        $row = array();
        $row[] = stripslashes($rs["username"]);
        $content[] = $row;
    }
    $content = array();
    $title = array("Institution Emails");
    foreach ($insresults as $rs) {
        $row = array();
        $row[] = stripslashes($rs["username"]);
        $content[] = $row;
    }
    $output = fopen('php://output', 'w');
    fputcsv($output, $title);
    foreach ($content as $con) {
        fputcsv($output, $con);
    }
?>