Expo React Native Android端FileSystem保存Excel文件报错求助

针对你在Android设备上遇到的ExponentFileSystem.writeAsStringAsync调用被拒绝的错误，可按以下步骤排查解决：

1. 先捕获具体错误原因 #

当前代码未处理异步错误，导致无法得知拒绝的具体原因。先给函数添加完整的错误捕获，打印详细错误信息：

const writeArrayToExcel = async (dataArray) => {
  try {
    const resultsMade = [["lap", "time"]];
    dataArray.map((lapTime, index) => {
      const lapName = `${lapWord} ${index + 1}`;
      const valLap = `${displayTime(lapTime).hours}:${displayTime(lapTime).minutesSeconds}:${displayTime(lapTime).centiseconds}`;
      resultsMade.push([lapName, valLap]);
    });

    let wb = XLSX.utils.book_new();
    let ws = XLSX.utils.aoa_to_sheet(resultsMade);
    XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
    
    const base64 = XLSX.write(wb, { bookType: 'xlsx', type: 'base64' });

    const currentDate = new Date();
    const formattedDate = `${currentDate.getFullYear()}-${(currentDate.getMonth() + 1).toString().padStart(2, '0')}-${currentDate.getDate().toString().padStart(2, '0')}_${currentDate.getHours().toString().padStart(2, '0')}-${currentDate.getMinutes().toString().padStart(2, '0')}-${currentDate.getSeconds().toString().padStart(2, '0')}`;

    const filename = `${FileSystem.downloadDirectory}Stopwatch-${formattedDate}.xlsx`;
    await FileSystem.writeAsStringAsync(filename, base64, {
      encoding: FileSystem.EncodingType.Base64
    });
    console.log("文件保存成功");
  } catch (error) {
    // 打印完整错误信息，排查具体原因
    console.error("保存失败详情:", error);
  }
};

const exportToExcel = async () => {
  await writeArrayToExcel(results);
};

运行后查看控制台输出，错误通常分为两类：权限不足或路径不可写。

2. 处理Android权限限制（最常见原因） #

Android 10+启用了Scoped Storage，直接写入Download目录需要媒体库权限，且FileSystem可能无法直接操作公共目录。可改用expo-media-library实现保存：

步骤1：安装依赖 #

npx expo install expo-media-library

步骤2：修改保存逻辑 #

import * as MediaLibrary from 'expo-media-library';
import * as FileSystem from 'expo-file-system';

const writeArrayToExcel = async (dataArray) => {
  try {
    // 请求媒体库写入权限
    const { status } = await MediaLibrary.requestPermissionsAsync();
    if (status !== 'granted') {
      console.error("需要授予媒体库权限才能保存文件");
      return;
    }

    const resultsMade = [["lap", "time"]];
    dataArray.map((lapTime, index) => {
      const lapName = `${lapWord} ${index + 1}`;
      const valLap = `${displayTime(lapTime).hours}:${displayTime(lapTime).minutesSeconds}:${displayTime(lapTime).centiseconds}`;
      resultsMade.push([lapName, valLap]);
    });

    let wb = XLSX.utils.book_new();
    let ws = XLSX.utils.aoa_to_sheet(resultsMade);
    XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
    
    const base64 = XLSX.write(wb, { bookType: 'xlsx', type: 'base64' });

    const currentDate = new Date();
    const formattedDate = `${currentDate.getFullYear()}-${(currentDate.getMonth() + 1).toString().padStart(2, '0')}-${currentDate.getDate().toString().padStart(2, '0')}_${currentDate.getHours().toString().padStart(2, '0')}-${currentDate.getMinutes().toString().padStart(2, '0')}-${currentDate.getSeconds().toString().padStart(2, '0')}`;
    const filename = `Stopwatch-${formattedDate}.xlsx`;

    // 先保存到应用私有目录
    const tempPath = `${FileSystem.documentDirectory}${filename}`;
    await FileSystem.writeAsStringAsync(tempPath, base64, {
      encoding: FileSystem.EncodingType.Base64
    });

    // 将文件移动到系统Download目录
    const asset = await MediaLibrary.createAssetAsync(tempPath);
    const downloadAlbum = await MediaLibrary.getAlbumAsync('Download');
    if (downloadAlbum) {
      await MediaLibrary.addAssetsToAlbumAsync([asset], downloadAlbum, false);
    }

    console.log("文件已保存至Download目录");
    // 如需分享可取消注释
    // await Sharing.shareAsync(asset.uri);
  } catch (error) {
    console.error("保存失败详情:", error);
  }
};

const exportToExcel = async () => {
  await writeArrayToExcel(results);
};

3. 其他排查点 #

• 确认FileSystem导入正确：import * as FileSystem from 'expo-file-system';
• 打印FileSystem.downloadDirectory路径，检查是否为有效路径（Android上应为/storage/emulated/0/Download/）
• 若使用Expo Go测试，确保应用权限已正确授予（可在设备设置中手动检查）

内容的提问来源于stack exchange，提问作者f1ian