Small example in the readme?

[stuart-bradley]

Having a little trouble figuring out how to get this library to work. It's not quite as simple as:

@action(detail=True, methods=['get'], renderer_classes=(XLSXRenderer,))
def report(self, request, *args, **kwargs):
    instance = self._get_cached_object()

    wb = Workbook()
    ws = wb.create_sheet("Mysheet", 0)
    ws.title = "range names"
    for row in range(1, 40):
        ws.append(range(600))

    return Response(wb)

>> KeyError: 'Worksheet 0 does not exist.'

So a little guidance would be appreciated for those of us who can't figure it out!

[FlipperPA]

The README shows to define it as a renderer in the parent class, for example:

class UserViewSet(XLSXFileMixin, viewsets.ModelViewSet):
    """
    A viewset that provides the standard actions
    """
    queryset = User.objects.all()
    serializer_class = UserSerializer
    renderer_classes = (XLSXRenderer,)
    filename = 'my_export.xlsx'

    @action(detail=True, methods=['post'])
    ...etc...

Have you tried setting the renderer on the parent class rather than within the method?

[FlipperPA]

@lutrasdebtra Any further information?

[FlipperPA]

Closing, no response.